DTS host failed to load or save package properly -
11-23-2005
, 09:19 AM
I am working with SQL 2000 SP4 and have two server in different
locations. When I Design a DTS package and click on Save As to copy it
to the second server it does, and i can keep designing and saving
package from Enterprise Manager in first server. But, when i try to
design it from second server it is throwing an error: "DTS host failed
to load or save package properly" and mades impossible to editing the
DTS package from second server.
Also, notice that trying to create a new package and setting an ActiveX
or a Connection Property component is happening the same problem, so it
seems like it is a problem with server installation or something else,
but it is working fine for anything else.
Please, if someone has any information about a similar problem post it.
Thanks. |