Re: Text file problem

On Thursday 20 May 2004 15:36 pm, Pete Ruckelshaus - CFList wrote: I'm trying to figure out what the most elegant way is to split these big files into smaller ones, and do it without killing performance.Has anyone done this? You could cfexecute something like split, or use Java file classes to

Re: Text file problem

[Non-cf suggestions] Not sure what database you are using but 77k record parsing/insert sounds like a prime candidate for Stored Procedure processing - take it to the database and let the database server do its magic. CF is obviously not built for / handling that kind of processing. Hmmm if

RE: Text file problem

Are you using MSSQL? If so, check out BULK INSERT. http://doc.ddart.net/mssql/sql2000/html/tsqlref/ts_ba-bz_4fec.htm -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 10:37 AM To: CF-Talk Subject: Text file problem Hi, I'm writing

Re: Text file problem

We're on SQL Server 2000, app servers are MX 6.1 on Win2K3. I saw the BULK INSERT command, the problem is that there isn't a 1:1 relationship between the columns in the database and the data in that tab-delimited text file (i.e. there are some system-specific columns in our database that don't

Re: Text file problem

I'm assuming that 1) this is a Win server and 2) you have access to it. Instead of opening the file directly, try setting up a file DSN.Then, you can let the system handle access of it and pull in records in groups. HTH. --Ben Doom Pete Ruckelshaus - CFList wrote: Hi, I'm writing an

Re: Text file problem

Is there a way to programmatically create/delete a file DSN from within CF MX 6.1/Windows?I didn't think there was... Pete Ben Doom wrote: I'm assuming that 1) this is a Win server and 2) you have access to it. Instead of opening the file directly, try setting up a file DSN.Then, you can