Backing up Packages

[rmchung]

Sorry if this is common sense, but I'm new to DTS here. I was wondering how do you go about backing up all the local packages that I've created? I can easily backup the databases I have, but seeing that packages are outside the database area, how can they be archived? In case SQL Server decides not to work for some ungodly reason, I'd like to have a backup of all the packages I've created. Also, is there an easy way to migrate these packages, say when I need to transfer everything to a "production" server. Is there an easier way than going into all my packages and doing a save as?

Thx!!

 

[JayKusch]

Morning!

OK ... there is not really a way to "backup" DTS packages per say BUT you can save them, for safe keeping, thru various means. Here is a link that tells all ...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_8ecl.asp

Thanks

J. Kusch

 

[MDXer]

Here is a nice little tool that makes saving your packages easier.

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

Once saved you can then backup the files. The only problem with this utility I have found is that you tend to lose the visual layout of the package.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[JayKusch]

MDXer is quite right on loosing the visual layout. I had several complex packages that I tested the above mentioned tool with and it hosed the packages to the point that it was not worth unscrambling all my connections, workflows and tasks.

Now for smaller, less complex, packages it works GREAT!

Thanks

J. Kusch