BCP I/O Error - SQL Server 2k

• THNQdigital

  SSC Eights!

  Points: 849

  More actions

  May 20, 2004 at 3:58 am

  #162584

  Hi All,

  i have a table with identity column( SQL server 2K). I am using BCP utility to insert data with format file and a flat file(.dat). Inside the format file i have omitted the identity column. and Inside the data file also i do not have anything corresponding to identity column.. ie ( Format and data file match in terms of number fo columns , order, type etc)

  When i try to run BCP ( from a batch file) i get an error like below

  "SQLState = S1000, NativeError = 0

  Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP format file"

  DO i need to create a view and then insert in to that?.. please let me know

  Thanks

  THNQdigital

   

• May 24, 2004 at 8:00 am

  This was removed by the editor as SPAM

• SQLIndia

  Ten Centuries

  Points: 1073

  More actions

  February 15, 2005 at 11:15 pm

  #542448

  Hi

  chechk this post..

  http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=152797

  SqlIndia