A DTS problem which is bothering me...
I can't believe it's almost July and it's pouring down with rain. I've been thinking about a problem a customer asked me about last week regarding DTS and the lack of interoperability between SQL Server 7 and 2000. To cut a long story short, I was asked to document the known DTS bugs for each (public) build of SQL Server 7 and 2000 - so, RTM to SP3/4 etc. As you probably know, the security in 2000 was changed and this introduced some compatibility problems; there are also some caveats around using the SQL Server 2000 client tools to edit packages designed in 7.0. However, this is just the tip of the iceberg. There are many DTS KB's and I need to check out. There's also a great resource here: www.sqldts.com which I highly recommend - I believe it's run by an MVP. I've had a lot of people ask for a setup option to not install DTS - I can understand how this would solve a lot of problems and I know SQL Server 2005 addresses this.