As it is a shared server, users do not have SA access, as that would be a big security issue. They only have access to their own DB.
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 13:53 To: CF-Talk Subject: RE: reading large text file 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:247742 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4