Comparing DTS Packages in SQL server 2000 & SQL server 2005

DTS Package Compare 2

Comparing DTS Packages in SQL server 2000 & SQL server 2005

Postby sukith » Thu May 17, 2007 6:07 am

Hi all,

Im facing a situation where I need to compare DTS package in SQL server 2000 and SQL server 2005. According to the functionality offered by DTS Package compare 2.1, it doesnt support such functionality. It will allow only to compare packages in SQL server 2000 environment. Does any one of you know a tool which offers the above functionality ? If so please respond.

thanks.
sukith
 
Posts: 1
Joined: Thu May 17, 2007 5:47 am

Postby Brian Donahue » Sat May 19, 2007 6:57 pm

Hello,

Sorry, I do not know of any utilities that do this. It may be difficult, because even though DTS is available to SQL Server 2005 as a 'legacy component', Microsoft have released SSIS as a replacement for DTS for SQL Server 2005. I also suspect that even the 'legacy' DTS for SQL Server 2005 is not entirely compatible with DTS Package Compare.

Sorry I can't be more helpful!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 0 guests