Execute the DTS from the Command line.
Lots of stuff has been posted about running DTS from a command line.
-----Original Message-----
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 09, 2003 5:48 PM
To: CF-Talk
Subject: Getting CF to trigger a SQL data export to text file
Hey gang,
Been bouncing around the MS SQL books online docs but haven't figured out
a
way to do what I want.
What I'm after is a way to take the contents of a DB view and export those
contents into an external text file, much like you can do the opposite
with
the SQL function BULK INSERT.
At the moment I'm doing it the hard way - query, loop on query, build up
long string, write string out to file with CFFILE. But it's slow and
clunky. I'm looking to offload the work onto the SQL server itself which
should be much faster.
Any prodding toward the solution would be greatly appreciated.
--Scott
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
