DTS Packages from 1 SQL Server to another

[rdfanta]

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??

Ray

[aneeshattingal]

read the following article

http://www.sqlserverce ntral.com/columnists/awarren/copyingdtspacka gestoadifferent server.asp

[rdfanta]

Thanks Much, I will check that out and let you know.

Ray

read the following article

http://www.sqlserverce ntral.com/columnists/awarren/copyingdtspacka gestoadifferent server.asp