title: SSIS Converting a char to a boolean/bit
body: <p>I have an SSIS package to load data; as you may recall there are flags that are in data files as Y/N char(1) when I am trying to load them as bit flags into SQL Server.  I am specifying the columns in the data file as <code>String [DT_STR]</code> and I have a data conversion task to convert them to booleans based on the following expression (I received the same conversion error just specifying them as DT_BOOL to begin with, despite SSIS asking me to say what values it should consider as boolean):</p>
  
  <pre><code>[ColumnName] == "Y" ? (DT_BOOL)1 : (DT_BOOL)0
  </code></pre>
  
  <p>Running the package gives an error and tells me <code>Invalid character value for cast specification</code> and <code>The value could not be converted because of a potential loss of data</code> on the actual import to SQL Server (via an OLE DB Destination).</p>
  
  <p>What am I missing here to get it to properly convert?</p>