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

  • LeeDuffy's avatar
    LeeDuffy
    New Contributor II
    2 years ago

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