No DTS task in DTS Designer

No DTS task in DTS Designer

Post by Caro » Sun, 20 Apr 2003 05:49:13

   I am using my Windows NT 4 desktop connecting to SQL2000 server on Win
2k. My DTS designer used to work well. But recently, I always get error
"DTS Designer Error" (no further error message) trying to open a DTS
package. Once I open it or create a new DTS package from the EM, under the
Task menu, I could not see any prepackaged task comonent as I could see from
the Server. I can only see the two items : "Register Custom Task" and
"Unregister Custom Task". So even I could create one new DTS package, I
could not add any task to it.
   I tried to uninstall the SQl client and reinstall SQL2k client and SP1 &
SP2 several time. It did not fix the problem. The EM MMC works well
otherwise from y  desktop. I could script the objects, start jobs....
   Can anyone give me any hint about this ?
   Thank you very much!



1. Register DTS custom task without DTS Designer

I just create a custom task with User Interface in Visual Basic 6.

I can register it with DTS Designer interface, but I need to do an
installation program (with Installshield for example).

I try to register my Task by this command line "regsvr32.exe
It work succeffully but when I want to create new "MyCustomTask" task in my
package the icon not appears into DTS Designer ?

Someone knows how to register custom task without DTS Designer ? by script
or command line or "file.reg" or ...

2. Impact of SCSI delays (enabling Brocade zoning) on "live" Oracle

3. DTS Transform Data Task fails in job where DTS Execute SQL Task does not

4. Job: Sr. DBA in Washington, DC

5. DTS Custom task in C# and threading model of DTS C# custom tasks

6. User Defined Table Column Name

7. DTS Designer Error, Tasks are missing

8. Oracle Enterprise Manager

9. DTS Designer - Wont Load Tasks-Metadata

10. DTS Designer Tasks

11. No task icons in DTS Designer GUI, WHY?

12. DTS Designer Task Captions Disappeared

13. DTS Designer Graphical User Interface-No Task's available