Lonnie Johnson
prodevmg at yahoo.com
Tue Aug 17 21:43:55 CDT 2004
Phil I felt so stupid after I sent that mail because I noticed that it was a path and command parameters. Sorry. I will try this method as well. I will have to get the path from the data admin. Phil Jewett <pjewett at bayplace.com> wrote:To clarify, I have always kept my DTS packages as files, not as database objects - thus the odd syntax. So my file in the below example is 'c:\mydts\DTS_mypackage.dts'. Note that the path/filename must always be from the SQL Server's point of view. But I must add that I never liked using DTS, as it is so inherently obscure, from design through execution. Nowadays I bulk insert if there is a whole lot of records to get the records into the database, and then use regular insert/update stored procedures to transform the data. You can use functions in SQL 2000, and thus get pretty fancy with data massaging. Phil Jewett >Is mydts a folder? Phil Jewett 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' >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!? New and Improved Yahoo! Mail - 100MB free storage!