Hi al

How do i run a DTS package from a SP, passing a Parameter

Thank

Brian
MCSE AACS

You can either use xp_cmdshell and DTSRUN or you can use the sp_OA*
procedures.

Have a look here.

Execution
(http://www.sqldts.com/default.aspx?104)

--

----------------------------

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


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

You can use xp_cmdshell and call dtsrun. You can build the
dtsrun command dynamically and use a global variable for the
parameter.
Another option would be to use the DTS Object model and OLE
Automation stored procedures (sp_OAxxxx procedures). You can
find an example of this at:
http://www.databasejournal.com/featu...le.php/1459181

-Sue

On Thu, 3 Jun 2004 04:46:05 -0700, Brian Potterton
<anonymous (AT) discussions (DOT) microsoft.com> wrote: