DTS Packages export method.

Question

Post reply

DTS Packages export method.

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
April 8, 2010 at 9:49 am

#222934

In one of our dev servers, there are a lot of DTS packages (SQL Server 2000 Engine) available which I need to copy and import to a new server. I am opening each files and saving it in Structured SQL File and copying it to a new server and importing.
Is there any other easy method (script) available which will help me to copy all the .DTS packages to indepedent Structured SQL Files?
Pls suggest...
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

There are free export tools available, like this one:

http://www.codeproject.com/KB/database/DTS_Export.aspx

I'm sure there are others around, try to google for them. Finding this one took me 1 minute.

-- Gianluca Sartori

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Hi Sourav

Try this.

http://www.nigelrivett.net/DTS/SaveAllDTSPackagesToFiles.html

Thank You,

Best Regards,

SQLBuddy

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 3

Thank you,, Guys for providing me the links. I infact though to search it in google, but .. not sure how effective the content could be, since after executing the same if it creates trouble, then that would be another headache to me.

🙂

Thanks.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

Greg Charles

SSC-Forever

Points: 45403

April 8, 2010 at 4:49 pm

#1148718

Here's another:

http://www.sqldts.com/242.aspx

Greg

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

Greg Charles (4/8/2010)
Here's another:
http://www.sqldts.com/242.aspx

This is the one I used. A couple of clicks and they were all done !!