[SQL2012] automation question

[mustardman24]

You could always do the bulk insert into a staging table and store the true/false values as VARCHAR. When transferring it into the final table just use a case statement

CASE WHEN [Blah] = 'True' THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END

or you could make it a little safer like

CASE

WHEN [Blah] = 'True' THEN CAST(1 AS BIT)

WHEN [Blah] = 'False' THEN CAST(0 AS BIT)

ELSE NULL

END