Joshua, Here's an article I wrote which details executing a DTS script from within ColdFusion:
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS You'll have to create a couple of stored procs, but it's just a cut-n-paste deal. -Dan > -----Original Message----- > From: Joshua Miller [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 12, 2003 12:57 PM > To: CF-Talk > Subject: RE: Writing Query Results to a CSV using CFFILE > > I'll second the notion for a DTS package. I've been using them > extensively lately to build downloadable subsets of data from SQL into > an Access DB and they're FAST! Although I didn't have much luck running > a DTS package from CF - I ended up writing an ASP script that handles > the DTS package and I call it via CFHTTP and have the ASP script return > a status code of success or fail. It's pretty easy and very powerful. > > If you're interested I can send you the ASP script to run the DTS > package. > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net > [EMAIL PROTECTED] > (704) 569-9044 ext. 254 > > ************************************************************************ > ************* > Any views expressed in this message are those of the individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to which it is > addressed and contains information that is private and confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to [EMAIL PROTECTED] > ************************************************************************ > ************* > > > -----Original Message----- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 12, 2003 12:43 PM > To: CF-Talk > Subject: RE: Writing Query Results to a CSV using CFFILE > > > What creating a DTS package which accepts a few parameters from CF. The > DTS would run the query, and export it also, like lickety split too. > > Dan > > -----Original Message----- > From: Wendy Copley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 11, 2003 6:25 PM > To: CF-Talk > Subject: Re: Writing Query Results to a CSV using CFFILE > > > [EMAIL PROTECTED] writes: > >Which database are you using? > > We're on SQL Server 7.0. > > I should add that the query itself doesn't seem to be the problem -- it > returns in a matter of seconds. The lag is almost certainly happening in > the process of looping through the query results and appending each line > to the file. > > Thanks. > _______________ > Wendy Copley > Web Engineer > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
