Discussion:
DTS Package Appears to be missing
(too old to reply)
Chris
2009-08-18 17:32:01 UTC
Permalink
I have a DTS package that looks like it now is missing when looking at it the
Management Studio (2005). I know it must be somewhere because the job that
kicks it off still runs fine and the files it creates stil get created, it is
just no where to be found in the GUI?

Any ideas on this would help.

Thanks,

-Chris
Lucas Kartawidjaja
2009-08-19 15:26:05 UTC
Permalink
Have you tried to look under Management > Legacy > Data Tranformation Services?

I can't remember from the top of my head if you can see it directly. One
thing to remember is that DTS has changed to SSIS in SQL Server 2005. Just in
case it did not, you might need to download and install the Microsoft SQL
Server 2000 DTS Designer Components. It is part of the Feature Pack for SQL
Server 2005
(http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en)
Post by Chris
I have a DTS package that looks like it now is missing when looking at it the
Management Studio (2005). I know it must be somewhere because the job that
kicks it off still runs fine and the files it creates stil get created, it is
just no where to be found in the GUI?
Any ideas on this would help.
Thanks,
-Chris
Continue reading on narkive:
Loading...