SQL SERVER, importing from CSV file. Data conversion error

Question

I am trying to import data from a CSV file into a table. I am presented by this error:

"Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "dstSupport" returned status value 2 and status text "The value could not be converted because of a potential loss of data."."

However, I do not even need to convert this column, as you see in the image below:

The column is of type bit, and I used DST_BOOL.

If its a string type make sure the destination length is big enough. — Alex K.
– Alex K., Commented Mar 20, 2018 at 16:15
If the .csv has a header, then make sure you use the 'top row as header' option. — Zorkolot
– Zorkolot, Commented Mar 20, 2018 at 16:33

Joshua Simon Bloom · Accepted Answer · 2018-03-20 17:08:26Z

2

This ended up being a parsing error. I had a string with commas within it, and these strings within the commas were being placed in my bit column. I fixed it by changing the delimiter from a comma to a pipe

answered Mar 20, 2018 at 17:08

Joshua Simon Bloom

6016 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL SERVER, importing from CSV file. Data conversion error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related