August 4, 2003 at 12:01 pm
I have a DTS packeages created on on SQL SERVER and I will like to transfer or move them to new server. How can I accomplish this tasks?
August 4, 2003 at 1:01 pm
You can use the utility DTSBakcup 2000 (http://www.sqldts.com/default.aspx?t=6&s=105&i=242&p=1&a=0).
Read this article: http://www.sqldts.com/default.aspx?6,105,204,0,0
August 4, 2003 at 1:08 pm
Thank you.
August 5, 2003 at 2:30 am
You can write a simple WSH script (.VBS, .JS) using DTS library to load DTS packages from SQL Server and save to StorageFiles to disk and second script to load packages from disk and save to SQL Server on target system ... see LoadFromSQLServer, LoadFromStorageFile, SaveToStorageFile and SaveToSQLServer methods
****************************************
1: The question is ... "What is a MahnaMahna"?
2: The question is ... "Who cares?"
****************************************
August 5, 2003 at 6:25 am
In enterprise manager, from the design view of the DTS package, select package->save as from the menu and change the name of the server to a different server. The DTS package will then be available on the new server.
August 6, 2003 at 8:51 am
you can also keep a copy of the msdb.dbo.sysdtspackages
1. copy msdb.dbo.sysdtspackages to another table say northwind..alldtspackages
2. copy the table across to the other server
on the destination server
3. if you want only the dts packages from source then
delete from msdb..sysdtspackages
4. insert into msdb..sysdtspackages
select * from northwind..alldtspackages
August 6, 2003 at 8:58 am
You can save DTS Package as Storage Structure file. This will save DTS package on disk as a file and copy it to another SQL server and load it from there.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply