>- see footer for list info -< It would be much easier and more efficient to us SQL Server Integration Services and write a small package that would import the csv into your DB you don't need direct access to the server a DB login will do. Though you will need SSIS running somewhere.
Sent from my iPhone so please excuse the brevity, poor spelling and any bad grammar. On 14 Oct 2010, at 00:43, "Lee Fortnam" <[email protected]> wrote: >> - see footer for list info -< > Hi All, > > > > I know this might be off topic for a CF discussion group but as CF is the > language I would be potentially handling this in I'll give it a shot. > > > > I have a service which regularly (once every 24 hours) needs to retrieve a > number of files from an FTP site. The issue is the file is 12MB in size as a > zipped CSV file. When unzipped the file is some 78MB in size. I need to > import all of this CSV file into an existing table, all fields will be > imported etc. > > > > Is there a GOOD efficient way to do this without killing the DB server or > having CF time out. This is on a dedicated instance of CF on a semi > dedicated box at CFMX hosting. I have no native access to the MS SQL 2005 DB > file system. > > > > Thanks in advance. > > > > Lee Fortnam > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- >> - cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >> - Lists hosted by www.Gradwell.com -< >> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
