Re: Execute a DTS package from within a vbs -
08-03-2003
, 02:35 PM
Yep.
from a .vbs file you can simply call a DTS package using the object model
Look up LoadFromSQLServer in BOL and the DTS Package object.
It will look remarkable similar to Page 1 of
Execute a package from a package
http://www.sqldts.com/default.aspx?6,104,215,0,1
--
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 |