Figured it out. I had an error elsewhere in the page. -----Original Message----- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Saturday, March 24, 2007 2:13 AM To: SQL Subject: Bulk insert
I am trying to submit the following through a cfm page <cfquery name="up" datasource="#dbname#"> BULK INSERT stgContacts FROM 'C:\CFusionMX\wwwroot\ileaflet\clients\1 \contacts.txt' WITH (FIELDTERMINATOR = '|') </cfquery> however it will not work. From Query Analyzer logged on wiht teh same user as the the user running the page I can run the command no problem but from the CFM page it is a no go. Yes the user has BULK INSERT privs ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2793 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
