Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
2 years ago

SQL Server Bulk Load Error.

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

 

 

 

  

1 Reply

  • 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).