Well you can also schedule the DTS package to run nightly or at anytime you desire. If in fact it is a scheduling thing you are looking for.
Not sure how you are reading your file, however, if you can read line by line (CustomTag in the Gallery I think), the do a LOOP over your read statement and insert the data that way. >>> [EMAIL PROTECTED] 11/20/02 10:39AM >>> Hello list. I have a text file that is comma and double-quote separated, with a line break that separates the lines. The first row contains the header information. What I am wanting to do is to import this into a SQL Server 2K table. I know that I can use DTS to do this, but I need to do this in ColdFusion code instead as a scheduled task. I have always in the past just used DTS Wizard to do this, not straight SQL. So, my question is, how do you import a text file into SQL Server? What would my query look like? I already have the cffile code in place looking at the text file. Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.
