SQL Server - Bulk Load in Linux

Question

Hi SMEs,Good day, hope all is well.&nbsp;Currently having some issue when running the bcp client in linux snaplex I was wondering on how can I pass the -u&nbsp;argument in the bcp client or any workaround or configuration that needs to be done in the snaplex?In the account I was able to put this option as&nbsp;https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/connecting-with-bcp?view=sql-server-ver16#available-optionsThanks,EmEm

smudassir · Answer

Please use bcp version 17 or lower for now. We don't yet support version 18 or higher. HTH

alchemiz · Answer

This has been resolve using a shell script. Thanks1. The SQL Server - Bulk Load documentation has the required instructions on your requirement for Windows environment1. The SQL Server - Bulk Load documentation has the required instructions on your requirement for Windows environment2. For a Linux node, you can try a similar approach to pass additional options to the BCP utility used by the SQL Server - Bulk Load Snap3. Create a shell script file (e.g., bcp.sh) that includes the bcp command and the desired options.For example:#!/bin/bashbcp "$@" -u4. This shell script will execute the bcp command with the provided arguments ("$@") and additionally pass the -u option.5. Make the shell script executable by running the following command:&nbsp;chmod +x bcp.sh6. In the Snap Settings, locate the BCP absolute path property and provide the absolute path to the bcp.sh script you created in the previous steps7. By specifying the absolute path to the shell script, Snap will execute the script instead of directly executing the bcp utility. This allows you to include any additional options or arguments you need in the script8. It is important to make sure the shell script is accessible from the Snaplex nodes where the Snap will be executed. You may need to copy the script to the appropriate locations or use a shared network path9. Using this approach, you can effectively pass the -u option or any other desired options to the bcp utility through the shell script specified in the BCP absolute path property on a Linux node

Forum Discussion

SQL Server - Bulk Load in Linux

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found