How can I have the database name in this sp to look into a
metadata table so I don't need to change the database name
each time I move this script to a different db. Thanks is
advance for your help. Daizy

exec
master.dbo.xp_cmdshell 'dtsrun /Smy_server /Umy_login /Pmyp
assword /Nmy_dts_pkg /Mdtspassword'

Are you using 2000 ? If not then you can't. If you are then look at Global
Variables and the /A switch to DTSRUN. Better yet use a Dynamic Properties
task.

In 7 you will need to do inside the package using a piece of ADO in
VBScript and assign the correct recordset fields to the correct parts of the
object model.



--
--

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

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