SQL SERVER, importing from CSV file. Data conversion error

▲
0
▼

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:

enter image description here

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

sql
sql-server
sql-server-2008
asked on Stack Overflow Mar 20, 2018 by Joshua Simon Bloom • edited Mar 20, 2018 by Joshua Simon Bloom

1 Answer

▲
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 on Stack Overflow Mar 20, 2018 by Joshua Simon Bloom

User contributions licensed under CC BY-SA 3.0