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 > > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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