Err saving DTS package on SQL2K SP4/Build 2187

microsoft.public.sqlserver.tools

1 Feb 2007 4:13 PM

DisgruntledTechGuy

Hello,

I am running into a very strange issue on all servers running this
distribution of SQL2K when saving DTS packages. Note that none of the
servers have SQL2K5 running on them (so
http://support.microsoft.com/kb/917406 is NOT applicable). Also, regardless
of whether the SQL2K server was upgraded from SP3a or built from scratch w/
SP4 & cumulative hotfix 2187, the same problem occurs, so this MUST be an
issue w/ this version of SQL2K.

That is the infrastructure. Now, on to the problem: I can save DTS
packages when in the DTS designer while on the server with no problem.
However, if I edit a package, forget to save it, and then exit the designer,
I am obviously prompted to save the package. If I select yes, I get the
following error and am unable to save the package, thus losing my changes,
some of which are many lines of code:

"Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: The DTS host failed to load or save the package properly."

This ONLY occurs when using the client components packaged w/ Build 2187.
If I repeat the process but connect to the server and edit the package via
the local client tools (running SP3a) on my laptop, the problem does not
occur. I also checked w/ a colleague who is running SQL2K5 RTM version of
the client tools, and he does not encounter the problem either. I also tried
performing all these actions while logged in to a server running just SQL2K
SP4, and the problem does not occur. Therefore, there has to be something
wrong w/ the cumulative hotfix build 2187. Please help as this is a serious
nuisance and can cause developers to lose lots of code changes if editing
packages while logged on to the actual server. Thanks!