Searching for my message I found two even better ways than my hack which was shelling out to run dtsrun from an sp (probably the most likely way to get yelled at by a dba anyway <g>). The first uses the DTS Object model, and the second executes dtsrun directly.
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS ...and this post by [EMAIL PROTECTED] Actually, there's back-door that has nothing to do with VB or COM... -In enterprise manager, right click on your DTS, and choose "Schedule Package" -Now schedule the Package for any time period. -On the root tree for that DB server, go to "Management / SQL Server Agent / Jobs" -Right click on the job you just created, and go to "Properties" -2nd tab over is "Steps", go there -Double click on the step you see, and there you'll see a command window with a command like this "DTSRun /~Zfdajkl;fjakf;s1359013u5rjfda;slf" this will be the unique command line for your DTS job. Paste it in a text file, and call it it "c:\DTS.bat" now you can do: <cfexecute name="c:\dts.bat" outputFile="c:\dts.log" timeout="600"> and that is that. -Jeff -- mailto:[EMAIL PROTECTED] Tuesday, March 11, 2003, 8:56:29 PM, you wrote: TW> jon. TW> interested...if you can dig it up, without too much hassle....thanks!! TW> tony TW> -----Original Message----- TW> From: jon hall [mailto:[EMAIL PROTECTED] TW> Sent: Tuesday, March 11, 2003 8:22 PM TW> To: CF-Talk TW> Subject: Re: Writing Query Results to a CSV using CFFILE TW> Great, this would be a job for the database not CF imo...create a DTS TW> package that writes out the csv file. Then either fire the DTS via an TW> SP, or use the DTS Object Model to execute. TW> This can be a bit complex, but not overly, and the DTS should be able TW> to complete an export of 150k lines in a few seconds, quite an TW> improvement from 30 minutes :) TW> I've made a lengthy posting on how to do this in the past, and I think TW> I can dig it up if you are interested. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
