No need using DTS. One word: bcp
and xp_shell to execute it and it is super fast. -----Original Message----- From: J W [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 6:40 AM To: CF-Talk Subject: Re: reading large text file Remember tho... DTS is great on SQL7 and SQL2000, but its GONE in SQL2005. It was replaced by the fairly overly complex SSIS (SQL Server Integration Services). Its not as cut and dry as DTS. You can import DTS tasks in as legacy within SQL2005 but We had some older tasks on SQL7 that didn't transfer over to SQL2005 right. I am not even sure if you can kick a SSIS task off within coldfusion either. Agreed. Huge text files, find some other means to import them into your database other than coldfusion. Jeff On 7/26/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > I am at a loss at why it was difficult to be honest - maybe the problem > was > you are not an SA on the prod box as normally, a DTS setup etc is a > breeze. > > > > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: 26 July 2006 14:08 > To: CF-Talk > Subject: Re: reading large text file > > Heh, Martin, I feel your pain. I just finished up a project yesterday > doing the exact same thing - do a search on "DTS" in the archives to see > all my questions about it. It isn't the easiest thing in the world to > set up and get all the pieces running, but once you do,it is about 2000X > faster than using CF. > > Of course, you need to be running SQL Server 7+ to be able to take > advantage of it. So, the first question is, what flavor DB are you > running? > > Ray > > Martin Thorpe wrote: > > Hello all. > > > > > > > > I am uploading a 74 + MB tab delimited text file that I am then reading > > and inserting the values into a database. The problem is it always > > times out, or just takes too long (did not finish over night!!!!) to > > read the file. It is uploaded fine. > > > > > > > > Any suggestions about how I may approach this to make it work with such > > large files? > > > > > > > > I looked at a bit of Java code someone had posted here but it went no > > quicker really. > > > > > > > > I was thinking of maybe chopping the file into slices and then > > processing but not too sure how I would approach this. > > > > > > > > Any opinions or ideas/tips would be gratefully accepted. > > > > > > > > Thanks for reading. > > > > Cheers > > > > Martin > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247816 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
