Ricardo,
You can run it as an EXEC from a query.
<cftransaction>
<cfquery name="addInfo" datasource="#application.dbcontact#">
EXEC MASTER..xp_CmdShell 'dtsrun /Smachine_name /Uuser /Ppassword /Ndtsname'
EXEC MASTER..xp_CmdShell 'move E:\data_load\data_file.txt
E:\backup_dir\lcbak'
</cfquery>
</cftransaction>
See SQL Server books for syntax on dtsrun Utility. I also included Exec line for
Move/Copy file to backup directory.
Dave
RICARDO SANOJA <[EMAIL PROTECTED]>@dfwcfug.org on 09/03/2001 09:51:54 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: OT: SQL Server DTS and CF
I hope that I am not repeating myself, I sent out this email on Saturday,
but i never received the email myself so I assume that it never got
through.
Here is the senario: I am receiving a .csv file through ftp to a server
that file will then need to be used as a transaction file and add, edit and
delete records in a database. I create a DTS package that will pull the
information into a temp table which I can then use to perform the database
updates that I want. What I need to know is how to execute that DTS
package
through CF script.
If you know how to do this, or if I am barking up the wrong, tree and you
have a better idea on how to do this better, please let me know.
Any information will be greatly appreciated.
Sincerely,
Ricardo Sanoja
_______________________________________________________
http://inbox.excite.com
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
This transmission may contain information that is privileged, confidential and/or
exempt from disclosure under applicable law. If you are not the intended recipient,
you are hereby notified that any disclosure, copying, distribution, or use of the
information contained herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard copy format. Thank
you.
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
