I want to run a DTS package to be triggered from a Excel workbook.
Please provide a simple sample how to run the DTS package from an
Excel workbook or alternatively how to run a DTS package from a SQL
Stored Proc with a simple sample please.

Thanks
Simon

Don't forget the DTS dlls will need to be registered on the Client.

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


"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote

You could incorporate the VBA code to accomplish this into a macro or other
VBA procedure.

Q315661 HOW TO: Run a SQL Server DTS Package from Visual Basic
http://support.microsoft.com/default...;EN-US;Q315661

-Doug

--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.


"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote