Post reply

DTS problems between SQL 7 SP1 and SP2

  • July 6, 2001 at 9:31 am

    #104447

    FYI, I ran across some problems with DTS packages when importing from a SQL 7 SP2 server into SQL 7 SP1 server.

    Some packages were unviewable on the SP1 server. Also, the packages failed to execute properly. I had to recreate the packages manually on the new server.

    Regards

    Jay

  • July 6, 2001 at 9:58 am

    #416949

    Hi Jay,

    This is in the readme.txt file for SP2. Here's the link (it may wrap):

    http://support.microsoft.com/support/kb/articles/Q254/5/55.ASP

    Scroll down to Section 5.10.6 Changes in DTS Packages. There Microsoft breaks the news that packages saved in SP2 format cannot be read by computers running SP1.

    K. Brian Kelley

    bkelley@agfirst.com

    K. Brian Kelley
    @kbriankelley

  • July 6, 2001 at 11:32 am

    #416954

    Save the packages with a password and you should be ok. For some reason, the password packages are all saved in the same format, but the non-password ones are not.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply