Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Unexpected error when open DTS

    I created a few DTS packages in our Test Server saving them as file.dts. When I try to open them in from the production server I get an Unexpected error and the DTS is not opened. Do you have any fresh idea for me, please? Thanks!!

  2. #2
    Join Date
    Feb 2002
    DTS is finicky I've found. This could be because the MSSQL servers are different versions, but most likely different configurations. It's not recommended, but you can try copying the row in the system table that contains the dts package into the production system table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts