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

**URL:** https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597
**Category:** General
**Created:** [24 June 2021 18:25 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597 "2021-06-24T18:25:20Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![IoTPlay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/iotplay/32/40_2.png) [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [24 June 2021 18:25 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597/1 "2021-06-24T18:25:20Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bdc872bf3aa05df9a6ac4b7cb0e531621b8fbbee.png)

Column 2 - would be the field "Customer".

**Data set below** :

```auto
[[
"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"]]

```

---

<div class="post-metadata">

### Author: ![IoTPlay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/iotplay/32/40_2.png) [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [24 June 2021 18:44 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597/2 "2021-06-24T18:44:11Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [24 June 2021 19:20 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597/3 "2021-06-24T19:20:50Z")

</div>

Have you resolved this?

---

<div class="post-metadata">

### Author: ![IoTPlay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/iotplay/32/40_2.png) [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [24 June 2021 19:22 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597/4 "2021-06-24T19:22:09Z")

</div>

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

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [8 July 2021 19:22 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-invalid-column-type/47597/5 "2021-07-08T19:22:32Z")

</div>

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