We have a software application which runs on a SQL Server database. We
distribute our blank database as a SQL Server Backup file, but how do I
distribute my DTS Packages?

Thanks for your advice,

- Joe Geretz -

Number of ways but undoubtedly the easiest is as a Structured Storage file
(*.dts)

Have a look here

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Thanks Allan,

I see a couple of useful options in that article.

BTW, is there any way to store a DTS package in a specific *database*, as
opposed to being global on the Server? And if not possible with SQL Server
2000, how about with v2005? Or is this something which is just not a good
idea for some reason?

Thanks,

Joe Geretz

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Saving a package to SQL Server is MSDB or nothing.
In 2005 the options are ever so slightly different but none of them will
allow you to save to a DB of choice.


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote