dbTalk Databases Forums  

DTS host failed to load or save package properly

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS host failed to load or save package properly in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Francisco Araujo
 
Posts: n/a

Default DTS host failed to load or save package properly - 12-07-2005 , 11:56 AM






We are working with SQL Server 2000 in a Windows 2003 Server, and
opening Enterprise Manager from this server to design DTS packages
works fine, but when this packages are copied to others company's
servers they cannot be designed.

So, after several tests and platform checking, we discovered that the
main server were this packages have been recently modified have a
Windows Service Pack 1 of a release candidate version and the others
servers have the last build. So, only servers with same Windows Service
Pack version allow designing DTS packages copied from main server and
once a server is upgrade to the last build Service Pack it fails
opening the packages.

So, it seems like we are unable to migrate this packages from main
server, so they can be used around company and we cannot upgrade the
Windows Service Pack because it won't open the packages again.

Any suggestions?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.