maybe a permissions thing =>http://msdn2.microsoft.com/en-us/library/ms188365.aspx Requires INSERT and ADMINISTER BULK OPERATIONS permissions
Wrap a cftry around the cfquery and dump cfcatch On 4/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > Thanks AJ, > > SQL and CF are both on the same box for sure, are there likely to be any > logs create anywhere by SQL that are likely to give me a better picture of > what's going wrong? > > Thanks, > > Rob > > -----Original Message----- > From: AJ Mercer [mailto:[EMAIL PROTECTED] > Sent: 23 April 2007 14:25 > To: CF-Talk > Subject: Re: Bulk Insert > > The text file needs to be on the SQL server > > Is CF and MS-SQL on the same box? > If not, you will need to get the text file onto the SQL Server. > > On 4/23/07, Robert Rawlins - Think Blue > <[EMAIL PROTECTED]> > wrote: > > > > Following on from my query this morning about the stored proc, I've > > started > > dabbling with the query in CF to start with, just as it feels more > > familiar. > > > > > > > > I'm struggling to get the following piece of code working though: > > > > > > > > <cfquery name="qCommitLogs" datasource="MyDSN"> > > > > BULK INSERT DeviceStaging > > > > FROM 'D:\test.txt' > > > > WITH (FIELDTERMINATOR = ',') > > > > </cfquery> > > > > > > > > <p>Done</p> > > > > > > > > This just returns a blank page, no error messages and nothing gets > > inserted > > into the database table. Both the TXT file and DeviceStaging are 4 > columns > > and the datatypes appear to match. > > > > > > > > 00:00:00:00:00,1,2007-01-01 12:00:00,1 > > > > 00:00:00:00:00,1,2007-01-01 12:00:00,1 > > > > 00:00:00:00:00,1,2007-01-01 12:00:00,1 > > > > 00:00:00:00:00,1,2007-01-01 12:00:00,1 > > > > 00:00:00:00:00,1,2007-01-01 12:00:00,1 > > > > > > > > Columns are: > > > > > > > > MacAddress Varchar(50) > > > > Port TinyInt > > > > DateTime DateTime > > > > Class TinyInt > > > > > > > > Any ideas on where to started with this? > > > > > > > > Thanks, > > > > > > > > Rob > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
