Hello:

I haven't had a whole lot of exposure on the DTS front,
and was wondering if after creating a package, would it be
possible to generate its script so that could be applied
later on either the same machine and/or on another machine?

Thanks.

It certainly is possible.

In 2000 saving to a VB .bas format is possible from the "File", "Save As"
menu
In 7 there is on the CD a ScriptPKG VB program which does the same thing

http://support.microsoft.com/default.aspx?kbid=239454

If you are simply concerned with moving a package between A and B then have
a look here

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

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Rob" <anonymous (AT) discussions (DOT) microsoft.com> wrote