Lonnie Johnson
prodevmg at yahoo.com
Tue Aug 17 15:48:18 CDT 2004
Is mydts a folder? Phil Jewett <pjewett at bayplace.com> wrote: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? -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses.