Thursday, March 22, 2012

DTS Packages from 1 SQL Server to another

Hi,

I am tring to transfer a number of DTS Packages from one SQL Server to another. Does anyone have any ideas.

I can save them as either DTS Strucure or Visual Basic Files, but how can I load them again.

After that I am going to rename the servers, I am going to rename the old one with _BAK and I am going to name the new one with the current servers name. Might this cause problems??

Rayread the following article

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp|||Thanks Much, I will check that out and let you know.

Ray

Quote:

Originally Posted by aneeshattingal

read the following article

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

No comments:

Post a Comment