Used DTS Migration Wizard but can't find the DTS Packs
Used DTS Migration Wizard but can't find the DTS Packs
(OP)
Hello,
I am trying to move some DTS packs from SQL 2000 to our new SQL 2005 server. I have used the wizard and it said it completed successfully, but I can not find the DTS packs. I re did the wizard and renamed the packs to go into a new DTS folder, but when I opened the folder it appears to be empty, however if I re run the wizard it says that the pack already exists on the destination server. I am very unfamiliar with DTS packs and totally unfamiliar with SSIS and none of the info on the internet is helping. Can someone please tell me where/how these DTS packs are stored on the destination server?
Thank you.
I am trying to move some DTS packs from SQL 2000 to our new SQL 2005 server. I have used the wizard and it said it completed successfully, but I can not find the DTS packs. I re did the wizard and renamed the packs to go into a new DTS folder, but when I opened the folder it appears to be empty, however if I re run the wizard it says that the pack already exists on the destination server. I am very unfamiliar with DTS packs and totally unfamiliar with SSIS and none of the info on the internet is helping. Can someone please tell me where/how these DTS packs are stored on the destination server?
Thank you.
RE: Used DTS Migration Wizard but can't find the DTS Packs
AFAIK, they're stored in the msdb database - check to see what you have with
CODE
CODE
On the GUI, you should find them in Object Explorer under Management>Legacy>Data Transformation Services.
HTH,
lex
soi là, soi carré