Error in BCP Utility

luludfs

• May 20, 2015 00:00

• Answered

Follow

Hello,

I'm using the component MSSQLDataWriter, and I'm receiving an error:
"Component [MSSQLDataWriter:MSSQLDATA_WRITER] finished with status ERROR. (In0: 2639 recs)
bcp utility has failed."

Can someone help me with this error? I couldn't find anything about it in the forum?

Regards.

• 

  simaj

  • May 21, 2015 08:52

  0

  Comment actions Permalink

  Hi,
  
  I suggest to verify the following, as these are the most common causes of BCP utility failure:
  
  

  Are the credentials correct?
  Is the server name and the table name correct
  Is the BCP utility correctly installed (It is not just standalone .exe file)?
  Is the connection opened towards the database?
• 

  pbizme

  • February 10, 2017 16:38

  0

  Comment actions Permalink

  I've gotten the same error when I tried to reference a parameter in for the database table name. If I change that and hard code the table name then it works. Is there a way to use the parameter here to make it dynamic?
• 

  admin

  • February 15, 2017 13:12

  0

  Comment actions Permalink

  Hi,
  I believe that it is probably related to "table name/parameter setup" issue that you have described in other topics, rather than BCP utility. Please see the response under topic How to do a dynamic insert into table.
  Thanks

Please sign in to leave a comment.