well yeah - a LOT better. CF is designed to optimize the processing of http requests. File I/O isn't a strong point. DTS can do about everything. You can even do data validation using DTS transformations in a vb script like language. You can also save the whole thing as a vb script and edit manually for even further control.
Mark -----Original Message----- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:01 AM To: CF-Talk Subject: RE: SQL Statement dumping data WOW!!, I haven't worked with DTS packages and not much with stored procedures. I will do some research. You think that this is a better solution then building a cf template and setup an automated task to run the cf template (in order to process the csv file)? Thanks, Jason Larson -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:50 AM To: CF-Talk Subject: RE: SQL Statement dumping data set up a DTS package to import the CSV file. create an SP to run the DTS package. use SQL Agent to schedule the SP. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:31 AM To: CF-Talk Subject: RE: SQL Statement dumping data What I am trying to accomplish is: I have a client that will be pushing up a csv file to a site and then I will setup a autmoated task that will dump all the data in a table and then refresh the data with the data in the csv file. Thanks for the quick reply Jason -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:26 AM To: CF-Talk Subject: Re: SQL Statement dumping data Do you mean delete all the data or Export the data? Clint ----- Original Message ----- From: "Jason Larson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 10:22 AM Subject: OT: SQL Statement dumping data > I was wondering if anybody had the sql statement that will allow me to > dump all the data out of the table in a database? > > Thanks for the help > Jason > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists