title: SSIS - Convert string value to binary bit value from flat file
body: <p>I think this may be a futile effort, but I'm importing a flat file to a table in MS SQL Server.  There's a value <code>Y</code> or <code>N</code> in the flat which I correspondingly wish to load as of course a 1 or 0 in the corresponding table column.  I don't suppose there is any trick to accomplishing as such?  It's having an incoming value of <code>Y</code> then 1, otherwise 0.</p>
  
  <p>Is this possible to do in SSIS?</p>