SQL Server Performance Forum – Threads Archive

Can i script DTS packeges somehow?

Can i script all existing DTS packages?
Will restoration of msdb restore all dts packages?

---

I don’t think there is any tool to script the DTS packages.
ONly you can save them to a file or repository etc. Yes MSDB restore will take care of all the jobs including DTS. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Actually there is such a tool I’ve never tried it but you can find it here http://www.swynk.com/friends/green/DTSBackupVB.asp
http://www.databasejournal.com/features/mssql/article.php/1462601 Bambola.

---

Great link Bambola! That’s very useful. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

---

I read the article
It’s sound nice but i don’t think i will install something additional on sql server. I probably will restore all using msdb restoration.
But.. half of my local DTS is saved to SQL Server and an other half to Meta Data Services
My question is if i save it to meta data will it still be restored with msdb?
I looked in sysdtspackages table: the names are all in it.

---

Thanks for the link Bambola and as specified its available/will work from SQL 2K version. The best option is to choose MSDB restoration, where I never had any issues.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>