I use sqlldr from a cfexecute call in CF. It's remarkably fast. I load some 25,000 rows (some 300 columns in length) from an uploaded txt document. It only takes a few minutes to do so.
On Wed, 1 Dec 2004 09:58:09 -0600, Aaron Rouse <[EMAIL PROTECTED]> wrote: > As best I can tell, yes. I use SQLLDR triggered by a nightly windows > scheduler for one project and works out great. Though DTS would be so > much nicer to use and could even import into a Oracle DB just doubtful > one would have access to DTS if in an environment that uses Oracle. I > have yet to try and see if I can use SQLLDR via an execution done in > CF. Only reason that I may not would be if some sort of security > solution was blocking it and of course if the executable itself was > missing from that server. > > -- > Aaron Rouse > http://www.happyhacker.com/ > > On Wed, 1 Dec 2004 07:12:47 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > > If you're using Oracle and can run sqlldr.exe wouldnt that be your > > best practice? For an Oracle system? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185807 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54