SQL2005 DTS Add-in Problem

• Ann Fassbender

  SSC Enthusiast

  Points: 170

  More actions

  October 31, 2006 at 2:06 pm

  #114935

  We are running both SQL 2000 Enterprise Manager and SQL 2005 Client tools on our XP workstation. After installing the SQL Server 2005 DTS add-in, we are having the following problem in SQL 2000 Enterprise Manager-- After making a change to a DTS Package (in EM), if you close the package window without saving your changes, it then prompts you to save your DTS Package. When choosing yes, it brings up a Package Error as follows:

  Error Source: Microsoft Data Transformation Services (DTS) Package

  Error Description: The DTS host failed to load or save the package properly.

  Yes we can save the changes before exiting but many developers close the DTS package window and then save. We don't want to roll this out to all of our developers and cause problems or annoyances for them when doing their work.

  I've tried the Microsoft SQL Server 2005 Backward compatibility Repair (in add/remove programs), I've tried reinstalling SP4 and tried a manifest file hack none of which have fixed the problem.

  Thanks

• debrucer1

  SSCertifiable

  Points: 5366

  More actions

  November 1, 2006 at 12:26 pm

  #669308

  no need to cross post... response on your other thread.

  Thank-you,
  David Russell
  Any Cloud, Any Database, Oracle since 1982