Run a DTS from a SP

From: srussell705 (srussell_at_lotmate.com)
Date: 12/14/04 

Date: 14 Dec 2004 09:44:19 -0800

What is the code to get a DTS package to run within my Stored
Procedure? I have to kick one off for a price update from an Excel
file.

TIA

__Stephen

Relevant Pages

  • Re: Run a DTS from a SP
    ... >What is the code to get a DTS package to run within my Stored ... I have to kick one off for a price update from an Excel ... OLE stored procedures to load and execute via the object model ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Sharing data between different application databases
    ... You could accomplish this with triggers or have a scheduled job that ... runs every n minutes and kick off a DTS package /Stored proc ...
    (microsoft.public.sqlserver.dts)