The BIT column in a datawindow is being returned as -1 when 1 and 0 when 0. This has been occurring for me using PB 12.0 and now with the new PB 2017. I am experiencing this in both SQL Server 2008 R2 and 2014. Has anyone run across this before. I am forced to either change the column to TINYINT or INT or put a CASE statement in the Datawindow such as "CASE WHEN MyBitColumn = 0 THEN 0 ELSE 1 END AS MyBitColumn"
Any help would be appreciated.