Forum Discussion

ash42's avatar
ash42
New Contributor III
3 years ago

Insert Special character in sql server table

I have a sql server bulk insert snap which have a varchar column in table. and i have a input document to this snap having this data 🙂 "• the ability to take part in daily activities " when i a...
del's avatar
del
Contributor III
3 years ago
Copy LinkReport

You may need to pass the -C (code_page) parameter to BCP. (I resolved some UTF-8 issues this way.)

I created a BCP.bat file that which my SQL Server Bulk Load snap references in the “BCP absolute path” parameter. Within the BCP.bat file, I have one command:

"C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\bcp.exe" %* -C 65001

I hope this helps.

  • del's avatar
    del
    Contributor III
    3 years ago
    Copy LinkReport

    @rajesh_mangipudi,

    I confess I am not an expert on this process, so my offering of information is based on what worked for me. I originally had to experiment a bit and lean on the snap documentation and Microsoft BCP documentation quite a bit with trial and error. I eventually got things to work for our case.

    But, there are a few things I failed to mention in my post above:
    You must install each of the required executables on each node of your groundplex. Including the required ODBC version and BCP. The executable is launched on the node that which the pipeline is running. This also includes the bcp.bat file you create - must be installed on each node.

    For my case, I let the installers install the applications to their default locations on the C: drive. However, we keep most of our service applications and dependencies such as SnapLogic and Java on the D: drive - which is where I created the bcp.bat file (D:\opt\BCP\bcp.bat). This is the path that I put into the snap configuration.

    I can’t confirm this will work for others, but I can confirm that it does work for us at this time
    .