What are the challenges you face when working across database platforms? Take the survey

Comparing DTS Packages in SQL server 2000 & SQL server 2005

sukithsukith Posts: 2
edited May 19, 2007 1:57PM in DTS Package Compare 2
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.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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!
Sign In or Register to comment.