When importing from a flat file (csv in my case) you are given the
option to "Suggest Column Types". Within this section you are able to
identify boolean values by specifying custom True/False values. In my
situation I have a lot of Yes/No fields. So I enter "Yes,No" as my
identifiers and it correctly suggests the "bit" type for the Yes/No
columns. However when I actually run the import which simply copies the
columns to a SQL Server table it fails with the following message:

The data conversion for column "******" returned status value 2 and
status text "The value could not be converted because of a potential
loss of data.".

Whats the point of having it suggest a Bit type if it can't actually
convert it when it comes to importing? I know I can get round this with
a "Data Conversion" transformation but it would be a lot easier if the
suggested boolean type actually enabled you to import the data as
such...?

Am I missing something?

James.