yeah - it looks like DTSRUN and CFEXECUE is probably the way forward...
does anyone know what if any error information is fed back by DTSRUN - cant
see anything in Books online, and I dont want to risk dropping and importing
if the data has not imported sucessfully...
cheers
Dan
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 03 January 2001 17:30
To: CF-Talk
Subject: RE: Executing SQL server DTS packages from CF...
Yo can execute DTS packages from a command prompt by using the dtswiz or
dtsrun utilities so sou should be able to do it. You could also try using
the OPENROWSET Transact SQL command to query the DTS package although I've
never done it and am not sure what it's supposed to do!
OPENROWSET('DTSPackageDSO', '/FC:\Dts\Dso.dts', 'Select *')
You can see how to use the dtsrun utility by looking at SQL books online.
Here's what the books online says it does:@
"The dtsrun utility allows you to retrieve, execute, delete, and overwrite a
package created using Data Transformation Services. The DTS package can be
stored in the Microsoft® SQL Server(tm) msdb database, a COM-structured
storage file, or Microsoft Repository. You can display the available
switches by entering dtsrun ?"
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 03 January 2001 17:02
To: CF-Talk
Subject: Executing SQL server DTS packages from CF...
Hi,
I have a number of DTS packages written for importing multiple text files
into SQL Server
(part of a process which sets up indexes/relationships for a temp copy of
the db, then imports a number of table in a specified order from text files,
checking referential integrity, and if they imported without any errors,
drop the Live tables, rename the temp tables, indexes, and relationships to
the names of the live ones...)
Now, the SQL for dropping and renaming works fine, and I can put all that
into stored procedures which I can execute from cf.
The problem comes with running the DTS packages in CF - looking at the SQL
documentation, I dont see quite how it could be done - they seem to need to
run through Enterprise manager
Can anyone help me?
The alternative of using CFFILE to import and manually checking all the
referential integrity does not thrill me - it would take much longer to
create, and be far less efficient in execution...
Any Ideas would be much appreciated...
Cheers
Dan.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
