Node-red-contrib-mssql-plus: "invalid column type..."

General
1

Hi @Steve-Mcl, I must be doing something stupid, but getting message: "Invalid column type from bcp client for colid 2. I got another bult upload working - so do not understand the issue on colid 2 - Customer nvarchar(20). But before I bug others to add my flow, hopefully the forum can point me a bit...

Below is the bulk upload config, and the inbound message.

Screenshot 2021-06-24 at 20.02.11

Column 2 - would be the field "Customer".

Data set below:

[[
"OPP-012765",
"Client 2 - Operations Planning",
"Client 2",
1234,
"USD",
null,
"Country Y",
0.75,
"Sales Person 1",
"Company Z",
"2021-06-30T00:00:00.000Z",
"2021-07-01T00:00:00.000Z",
"2023-03-01T00:00:00.000Z",
"Project Mgr 1",
"Project Type 2"]]
2

I am looking into diff with char, nvarchar, etc. Let me look into this first.

3

Have you resolved this?

4

Yes thank you, sorry to bug you, needs a fair amount of fiddling and ensuring columns are correct. Not you,..., me.

5

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.