[AccessD] RE: Pass Through to DTS package

Phil Jewett pjewett at bayplace.com
Tue Aug 17 18:00:08 CDT 2004


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 <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'


>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