March 11, 2009 at 6:16 am
Hi,
Am in need of using the SQL server 200 DTS packages in SQL Server 2005 Management Studio. I tried taking the data for a sample package from msdb of SQL 2000 server and inserted into the msdb of SQL 2005 server. I find that the package got listed under legacy\DataTransformation Service but yet am unable to open it for editing or execution. Please let me if i need to take care of anything else in making this process a successful attempt.
Thanks
March 11, 2009 at 9:42 am
I have only migrated DTS packages to SQL 2005 by saving them as files then importing them in SSMS, so I don't know if your method will cause any problems. I do know that you need to go to the MS download site to download and install the following:
Microsoft SQL Server 2000 DTS Designer Components and Microsoft SQL Server 2005 Backward Compatibility Components.
These are necessary to edit and run DTS packages in SQL 2005.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply