You can use <cfexecute> to run DTSRun.exe.

If you search the SQL server Help, you can find out more info on the
syntax to use DTSRun from command line.

On Fri, 15 Oct 2004 13:26:50 +0200, Hugo Ahlenius
<[EMAIL PROTECTED]> wrote:
> How does one execute a DTS package from CF?
>  
>  --
>  Hugo Ahlenius
>  
>  -------------------------------------------------------------
>  Hugo Ahlenius                  E-Mail: [EMAIL PROTECTED]
>  Project Officer                Phone:            +46 8 230460
>  UNEP GRID-Arendal              Fax:              +46 8 230441
>  Stockholm Office               Mobile:         +46 733 467111
>                                 WWW:       http://www.grida.no
>  -------------------------------------------------------------
>  
>  
>  
>  | -----Original Message-----
>  | From: Robertson-Ravo, Neil (RX)
>  | [mailto:[EMAIL PROTECTED]
>  | Sent: Friday, October 15, 2004 13:14
>  | To: CF-Talk
>  | Subject: RE: CSV import into DB
>  |
>  | DTS
>
>
>  |
>  |
>  |
>  |    _____
>  |
>  | From: Mark Drew [mailto:[EMAIL PROTECTED]
>  | Sent: 15 October 2004 11:48
>  | To: CF-Talk
>  | Subject: CSV import into DB
>  |
>  |
>  |
>  | I am doing an automated insert of a CSV file  into a MS SQL database.
>  | I am sure this has been done a million times, so I was
>  | wondering if there is a better way that upload CSV, loop
>  | through each line and insert each line one at a time into the
>  | db. Is there a better batch import method?
>  |
>  |
>  | --
>  | Mark Drew
>  |
>  | coldfusion and cfeclipse blogged:
>  | http://cybersonic.blogspot.com/
>  |
>  |    _____
>  |
>  |
>  |
>  |________________________________
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to