November 24, 2005 at 1:13 pm
I help to maintain a Data Warehouse environment using SQL Server 2000.
We want to move from our current physical database server (DWPROD) to a
new one (DWSQL).
I have copied all the .dts packages over to the new server.
When I open any of them, I get an error with the following description:
"The DTS host failed to load or save the package properly".
Since receiving the initial error, I have:
1) changed the relevant .udl file to point to dwsql instead of dwprod in the 'data link properties' to ensure connection is to new server.
2) Cleaned up orphaned records after the transfer of logins / password.
However, the error persists.
What would you suggest to look at to identify the source of the error?
Or, should I use a different method to copy the .dts packages.
Thanks in advance.
November 24, 2005 at 1:51 pm
You can use this utility to transfer the packages:
DTSBackup 2000
http://www.sqldts.com/default.aspx?242
November 25, 2005 at 11:36 am
For a few DTS packages you might simply copy each package to a structured storage file; copy the files to the new system; and estore them there. For details go to the index of BOL for'structured storage files' and follow 'How to save a DTS package to a structured storage file' and then 'How to open a DTS package saved to a structured storage file'
November 26, 2005 at 9:30 am
Can you verify that both servers are on the same build? I would check the MDAC as well.
You can also try to copy them directly using T-SQL like so:
-------8<---------
Insert targetlocalserver.msdb.dbo.sysdtspackages
Select * from sourcelinkedserver.msdb.dbo.sysdtspackages
Where name = 'Name of DTS package'
-------8<---------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply