Re: [ cf-dev ] Importing large amounts of data to sql

[Steve Powell]

Would you not be better using a Data Transformations Service Package inside SQL Server?   We regularly import aorund 80Mb of data exported form our overnbight porcessing systems for live reports. It usually takes about 25 mins on a fairly lowly SQL box.   If all your CF is doing is reading the CSV and stuffing the data into columns in a SQL table a DTS will be vastly more efficient.   If the file is a standard format, you can set up the DTS using its wizard and save the packge. Then just replace the file each time and run the package again.   You can script inside DTS packages and get clever if you so wich, heirarchical data set and so on but that's less straightforward. there are some good books on DTS. Its a vastly mis-understood and under-estimated component inside SQL Server.       ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 5:48 PM Subject: RE: [ cf-dev ] Importing large amounts of data to sql Does this help? http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=18243&forumid=4 Rafe