Comparing DTS Packages in SQL server 2000 & SQL server 2005

[sukith]

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.

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521