Benjamin Wright-Jones

Exploring data and distributed systems [I also cross-post to]

June, 2004

  • Benjamin Wright-Jones

    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: 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. 

  • Benjamin Wright-Jones

    Hello & Let's talk about SQL Server


    Welcome to my blog - I'm going to use this site to share my thoughts, ideas and experiences with SQL Server & some VB/C#.NET.  I'll most likely concentrate on the current 2000 and pending 2005 release which should be with us soon.  The second beta is just round the corner.   I'm particularly interested in the CLR hosting, replication enhancements and DTS. 

    I'm hopefully going to PDC this year, I haven't heard or seen any published information yet - I'll post an update when a date has been confirmed. 

    PDC 2005 information can be found here:
    Tech Ed 2005 information can be viewed here

Page 1 of 1 (2 items)