BCP in a table

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  September 28, 2007 at 4:50 am

  #178167

  Comments posted to this topic are about the item BCP in a table

• Hugo Sanguino

  Grasshopper

  Points: 24

  More actions

  March 18, 2009 at 3:24 pm

  #962298

  The SP fails when my table has a column name beginning with a numeric.

  I.e.

  CREATE TABLE [dbo].[txgeoTable]

  (

  [EDIPOKey] [int] NOT NULL ,

  [TranNo] [char] (10) NULL ,

  [940SentDate] [datetime] NULL ,

  [Status] [char] (1) NULL

  )

  GO

  This works ok.

  EXEC dbsp_bcp_out txgeoTable, mydb, 'c:\'

  This doesn't work.

  EXEC dbsp_bcp_in txgeoTable, mydb, 'c:\'

  Error Message:

  Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '940'.