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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
