December 20, 2006 at 3:15 pm
I used the DTS import wizard and successfully imported my DTS packages. However, when I look in SSMS in Legacy / DTS, there is nothing there. I have also tried BIS and using the Execute SQL 2000 DTS task. When I get to the select package part, there is nothing there.
If I run the wizard again, it says that the package already exists. I can see the package listed in msdb in the sysdtspackages90 table.
I have installed the 2000 DTS package, so the editor is there.
I am new to 2005, please help.
December 20, 2006 at 6:43 pm
Chris,
Have you looked under Management - Legacy - Data transformation Services?
DTS packages should be listed there.
Julia
December 21, 2006 at 10:21 am
Yes, I looked there. No packages were listed.
I found a way to get it done. I had to save the DTS on my 2000 server out to a file and then import the file. After that, they magically appeared. I don't know why the wizard dosen't work.
Thanks.
December 21, 2006 at 3:16 pm
Make sure you install DTS addins to edit/maintain the dts packages in 2005.
Microsoft SQL Server 2000 DTS Designer Components
MohammedU
Microsoft SQL Server MVP
December 26, 2006 at 8:14 am
I believe if you go into SSMS and under registered servers you click on the "integration Services" button and add your 2005 box you will see the packages listed under Stored Packages\MSDB
Thanks
Rich
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply