cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Bulk Load Error.

arvindnsn
Contributor

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

arvindnsn_0-1716411577266.png

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

 

arvindnsn_2-1716411650772.png

 

 

Please provide any insight to resolve this.

Thanks

Aravind N

 

 

 

  

1 REPLY 1

LeeDuffy
New Contributor

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