[AccessD] RE: Pass Through to DTS package (Lonnie Johnson)

Phil Jewett pjewett at bayplace.com
Tue Aug 17 15:25:07 CDT 2004


I've always run my DTS packages by putting the command in a stored
procedure and running that.  But I imagine you could put the command
line directly in the pass-through query; e.g.

exec master.dbo.xp_cmdshell 'dtsrun /Fc:\mydts\DTS_mypackage.dts
/NDTS_mypackage'

Phil Jewett

>Does anyone know if you can send instructions via a pass though query
to start a SQL Sever 2000 DTS package?
 




More information about the AccessD mailing list