i have BIT data type in sql server and i am trying to migrate it to snowflake but i am not able get the data into snowflake properly 0 goes as 0 but 1 goes into as 255 when i DT_UI1 data type to output the column in sql server
can anybody help me how to send bit data type column to snowflake
Advertisement
Answer
DT_UI1 is probably an unsigned integer and you want a regular signed integer.
Failing that you can just select instead
CASE WHEN [BitColumn] = 1 THEN 1 ELSE 0 END
or
CAST([BitColumn] AS INT)
To get an integer on the source side