MS SQL Server bit column exported as boolean
The problem is, SQL Server has a bit data type. It does not have a boolean, while SSISuses .Net data types, not SQL data types. It supports boolean, not bit. Though it has built-in conversions, to resolve problems like that. So in my opinion, you need to use a derived column to solve that.
Add a IIF in your select to convert Boolean to 0/1 to export:
SELECT Name, Code ,IIF(EuroZone = 1, 1, 0) AS EuroZone ,IIF(Visible= 1, 1, 0) AS VisibleFROM your_table