Ok, this is not obviously broken for me. I need a bit more information from you. The Bulk Load snap uses the bcp utility to load data into SQL Server.
The data fed into the Bulk Load snap is written to a temp file using custom delimiters. Specifically these:
FIELD delimiter: [|!,!|]
ROW delimiter: [|!/n!|]
We invoke bcp specifying the temp data file plus the custom delimiters. The data file would of course explain what we’re seeing in the db, though this is a bit tricky to inspect because it is deleted after the load snap finishes.
I see a space after the first json block before another field delimiter, which should be a record delimiter, and then repeat of data. Hmmm…
What version of SQL Server are using? The version of BCP would be helpful too (bcp -v). Are you running a Windows or Linux plex? Sample input would be helpful – maybe you can download the data that is fed into the Bulk Load snap.
We can actually replay the data and invoke BCP from the command line. It’s good you checked that could load data using SQL Insert – a nice cross check. Something with the shape of the data going into bulk it seems.
Sadly we switched to using a straight SQL insert so I don’t have any more examples. Also due to privacy I am limited to what I can send you.
We are on SQL version: 2019,
We are using BCP version: - That is on the snaplogic side so we aren’t sure.
And it is a windows machine. Windows 2019 Data Center
I wish I could offer more help but its definitely bulk uploader or the bulk uploader snap. During validation the data looks fine and swapping out the control for a sql insert works fine.
Thanks
