May 8, 2008 at 2:43 am
Hi,
I tried to import DTS from SQL2000 to SQl 2005 which is happen correctly but the problem is that, it is allowing me to edit /open it for which it required set to be run of sql component - 'sqlserver2005_dts.msi'. I downloaded the msi file and run the setup but still not able to open the DTS in 2005 giving same error (SQL Server 2000 DTS Designer components are required to edit DTS packages)... Any idea????
Pls help
May 8, 2008 at 5:37 am
I don't think its possible to look at DTS packages in SSIS VS you can run them but you can open and edit them.
May 8, 2008 at 11:15 am
Hi,
Add the execute DTS 200 package task first and access/add the DTS package from there. If you have migrated, then you can see the packages under SSMS, management legacy node and from there you can open and edit them and execute them.
-V
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply