I need something I can run in a .bat file as it loads in a batch server. These databases have about 20 million records and the files can be quite large. CFFILE might time out, trying to write out a file with 80 fields and 50,000 records.
Jeremy -----Original Message----- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, April 06, 2006 10:45 AM To: CF-Talk Subject: RE: SQL 2005 and getiing data out What about using CF to do it? Query the DB and use cffile to dump out a csv. > -----Original Message----- > From: Jeremy Bunton [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 06, 2006 8:12 AM > > I have an application that needs to run a query against a > 2005 database and > then export that data to a .csv file. I tried BCP first and > it didn't do > what I needed really so then I moved to sqlcmd, which had the > options I > needed. The problem is sometimes the queries the users build in the > interface to pull the records get quite large. Some have IN > clauses with > several thousand items in the list. Both bcp and sqlcmd die > on these because > the command arguments are too long. The quires run fine in > coldfusion and in > the query analyzer, I just can't find a method to pull out > the records. Any > ideas?? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237112 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
