Moving DTS

Question

Post reply

Moving DTS

Nita Reddy

SSCarpal Tunnel

Points: 4182
More actions
November 9, 2004 at 7:26 am

#85979

How to Move DTS pacakages itself from server to another.
I have 300 DTS pacakages and I am moving my database to another server how should I do it?
Nick
I HAVE 300 DTS shall I go and do each manually or I can do all 300 at a time??

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Dave-175556 SSC Eights! Points: 896 More actions · Answer 1

Open the DTS Package, Save it as script file.

copy it to destination server.

Go to DTS open package and then save on the server.

Nita Reddy SSCarpal Tunnel Points: 4182 More actions · Answer 2

Thanks Also

Also I am having issue with replication how to do restore replication on another server, we are using transactional repl.

Thanks

N...

Steve Jones - SSC Editor SSC Guru Points: 737403 More actions · Answer 3

Generate the scripts for replication and run them on the next server.

hoo-t SSChampion Points: 12713 More actions · Answer 4

A quick search on SQLServerCentral.com yielded the following article on transferring DTS packages -

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

There were also numerous threads in the forums that showed up in that search.

My search was simply the words "copy" and "dts" in the search box. I figure ANYTHING would be better than manually copying 300 DTS packages between servers!!!!

Steve

hoo-t SSChampion Points: 12713 More actions · Answer 5

OH! OH! OH! Just found this!!!! (Well, ok, I didn't find it, I found another thread that references it. Thanks Frank!!!)

http://www.sqldts.com/default.aspx?105

Steve

kknudson SSCarpal Tunnel Points: 4986 More actions · Answer 6

The DTS Backup package works well,

There is a switch on one of the panels to retain formatting.

Don't forget to check it, even so a few will need to be laid out again. Although they work fine.

KlK

Guus Kramer Ten Centuries Points: 1031 More actions · Answer 7

Hi

I use the DTSbackup2000 utility ( freeware ) .....smooth and easy.....recomandable..

GKramer

Moving DTS

Cookies on SQLServerCentral