cancel
Showing results for 
Search instead for 
Did you mean: 

Azure SQL Bulk extract-- BCP absolute path

Himani
New Contributor

Hi,
I am using a Azure SQL bulk extract snap and it is asking me to mention the BCP absolute path. I am not aware of this. Can anybody pls help me out?

4 REPLIES 4

marjan_karafilo
Contributor

Hi @Himani ,

Maybe this links will help you to resolve the issue:
https://azure.microsoft.com/en-us/blog/bcp-and-sql-azure/
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/20283393/Azure+SQL±+Bulk+Extract

Also, can you provide the error of the Azure SQL bulk extract snap?

BR,
Marjan

Himani
New Contributor

Failure: BCP program not found, Reason: Could not find BCP program in system path, Resolution: Make sure BCP program is in system path or indicate its location using BCP absolute path field.
this is the error.

I think that you have to install bcp command-line utility or provide the location where it is installed.
Please check the links that I have provided in the previous post.

BR,
Marjan

@Himani , may I know which OS your plex is running on? If the bcp utility is installed then you can add the bcp to the system path and you should be all good. Else, you can provide the absolute path of the bcp utility.

If bcp is not installed then you can install following the instructions here:
Windows: bcp Utility - SQL Server | Microsoft Docs
Linux: Install SQL Server command-line tools on Linux - SQL Server | Microsoft Docs