search

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

batch data load is failing with Invalid column type from bcp client for colid 2. #58

Open maulikdoshi82 opened 2 years ago

maulikdoshi82 commented 2 years ago

Hi Steve,

Thank you for your response and real apologies for not reverting you sooner. As we had to go for demo, we used the static file load at the time of starting DB and progressed to other places.

Back to bulk insert now and this looks pretty good. I'm generating an array of around 98000+ records and pushing it in sql-server via batch mode. Array does get created quite quickly though while pushing the data in sql, it's throwing: Invalid column type from bcp client for colid 2.

Which seems a bummer as I'm creating table along with the bulk insert, which means schema is exactly the same. Kept all my fields as nullable too so it shouldn't be the issue. Would you have any recommendation to look for in fixing this issue?

Steve-Mcl commented 2 years ago

Are you able to provide a minimum demo flow that reproduces this issue? Could you post it in a reply?

Also, what versions are you running...