Error in BCP Utility

Support/help with CloverETL implementation problems

Luludfs
Posts: 7
Joined: Sun May 17, 2015 11:06 pm

Error in BCP Utility

Postby Luludfs » Wed May 20, 2015 8:13 pm

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
Posts: 27
Joined: Fri Apr 03, 2015 12:27 pm

Re: Error in BCP Utility

Postby simaj » Thu May 21, 2015 9:52 am

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?
Jakub Sima
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

PBizme
Posts: 9
Joined: Thu Feb 09, 2017 2:59 pm

Re: Error in BCP Utility

Postby PBizme » Fri Feb 10, 2017 5:38 pm

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?

jandikovae
Posts: 23
Joined: Fri Nov 04, 2016 8:51 am

Re: Error in BCP Utility

Postby jandikovae » Wed Feb 15, 2017 2:12 pm

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
---
Eva Jandikova
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support


cron