SQL Server Bulk Load Error.

[arvindnsn]

Hello,

   To perform truncate/load data strategy for around 20 million records from SQL Server Source to SQL Server Target, I am trying to use SQL Server Bulk Load Snap. I understand that the BCP utility has to be installed and i have installed BCP utility under C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn in our Windows Server where the Snaplogic execution node resides.

I am getting the following error when trying to load

Below screenshot is the Snap settings for SQL Server Bulk Load.

Please provide any insight to resolve this.

Thanks

Aravind N

[LeeDuffy]

Hi Aravind, 

One thing that worked for me was to add the full path of the .exe file, so the end of your path would be Binn\bcp.exe (depending on your file name).