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.
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?
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?
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