Cannot save DTS package

  • Hello, I am using SQL Server 2000 sp3a in an Active/Passive cluster arrangement.  I have a DTS package that has been running fine everyday for over a year. Today I opened the package in the DTS Designer and modified one query in an Execute SQL Task. When I clicked the Save button, I got the following error:

    Package Error

    Error Source : Microsoft OLE DB Provider for SQL Server

    Error Description : Unspecified error

    and the modifications were not saved. The package is saved with location option "SQL Server". I have tried logging off and back on again as a Cluster Administrator user, but I get the same error every time.

    Any ideas what is causing this and how to fix?

    -Steve

  • If I remember correctly, this has to do with a problem in SP3.  At the moment, I can't remember exactly what fixed it, but I think it was an update from MS.

  • Xnl28, I found what I was talking about.  We had to go to MS to get a HotFix.  It was Hot Fix for Microsoft Knowledge Base article number Q814113.  Bascially, it was a update for the DLL dtsui.dll.

  • Lee, I found Microsoft Knowledge Base Article - 814113 (searching for Q814113 yeilded no results), but this is not the problem I am experiencing.

    814113 described the following symptoms: "After you upgrade your SQL Server client tools to SQL Server 2000 Service Pack 3 (SP3), DTS Designer and SQL Server Enterprise Manager may disappear unexpectedly because of an unhandled access violation. SQL Server Enterprise Manager may generate an access violation before it disappears that is similar to the following access violation:mmc.exe - Application Error"

    The symptoms I am experiencing are different in these ways: the problem just started a few days ago, not when I installed SP3 (which was a few months ago); DTS Designer and EM don't disappear at all - I just can't save changes made to a package; the error produced is not an access violation, but an OLE DB error.

    But I thank you for suggesting something to look into.

  • can you save the changes to a .DTS file and then delete the old and install the new as a file and then resave to the server?

  • That can also happen if you renamed the server (computer name).

Viewing 6 posts - 1 through 5 (of 5 total)

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