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?