โ05-09-2018 09:12 AM
Hi,
After creating the SQL database in MS Azure, In SnapLogic when we actually provide the โSchemaโ and โTableโ name for the AZURE SQL BULK EXTRACT Snap, it is providing me the error โFailure: BCP program not found, Reason: Could not find BCP program in system pathโ.
Can you please help me to set or resolve the BCP Path here. Is there any path that I can get it from MS Azure SQL DB?.
Thanks
โ12-12-2018 10:03 AM
Did anyone every figure this out?
โ12-12-2018 01:06 PM
The snap requires a field " BCP absolute path" that needs the
Absolute path of the BCP utility program in JCCโs file system. If empty, the Snap will look for it in JCCโs environment variable PATH.
โ12-21-2018 10:40 AM
More specifically one needs to include the full path to the executable not just the containing directory. So for CentOS 7 ground plexes pleas enter,
/opt/mssql-tools/bin/bcp
This only works on groundplex(s). Which is odd, it could be pre-loaded on the cloudplex(s) as well.
There does not appear to be such good documentation on installing MS SQL Tools on CentOS and configuring the groundplex to ensure that the the JCC runtime can see it.
โ12-21-2018 10:42 AM
BTW, I did get this resolved but there appears to be an issue with the Snap. It fails if you use BigInt types in your SQLServer tables. See the ticket number 27858