Here's how to do it in cf.
LoadFromSQLServer Syntax:
ObjectName.LoadFromSQLServer("ServerName",
"ServerUserName",
"ServerPassword",
"Flags",
"PackagePassword",
"PackageGuid",
"PackageVersionGuid",
"PackageName",
"pVarPersistStgOfHost")
<cftry>
<cfobject type="COM" name="objDTS" class="DTS.Package"
action="CREATE">
<cfcatch type="Object">
<cfset error_message = "The DTS Package Object Could Not Be
Created">
</cfcatch>
</cftry>
<CFSET r = objDTS.LoadfromSQLServer("TEST","sa","",0,"","","","test","")>
HTH,
Robert Hinojosa
[EMAIL PROTECTED]
972.243.4343 x7446
-----Original Message-----
From: RICARDO SANOJA [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 03, 2001 9:52 PM
To: [EMAIL PROTECTED]
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 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
