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

DTS package

I am tring to back up my remote site's data to my computer here at home.

I use DTS wizard from EM and copy objects and data (is this correct?)

Then I choose to save the package as SQL package, give it a name and times to run etc.

However I can't find where it has saved if indeed it has.
I've looked under SQL server agent jobs and management local packages but it's not there.

I'm sure I'm doing it all wrong!

Thanks for any advice.

JBDid you create the package on Your computers Sql Server or on the Remote Server? I am sure that is the problem. Check both locations.|||Thanks Wes,

But.. how on earth do I create this on the remote Database?

JB