05-22-2024 02:02 PM - edited 05-22-2024 02:03 PM
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
06-04-2024 01:08 AM
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).