title: SSIS Package Fails on Status Code 4
body: <p>I've created an SSIS package that executes inline SQL queries from our database and is supposed to output the contents to a text file.  I originally had the text file comma delimited, but changed to pipe delimted after researching the error further.  I also did a substring of the FirstName field and ensure that the SSIS placeholder fields matched in length.  The error message is as follows:</p>
  
  <pre><code>[Customers Flat File [196]] Error: Data conversion failed. The data conversion for   
  column "FirstName" returned status value 4 and status text "Text was truncated or one or more 
  characters had no match in the target code page.".
  </code></pre>
  
  <p>The SQL statement I'm using in my OLE DB Source is as follows:</p>
  
  <pre><code>SELECT     
  dbo.Customer.Email, SUBSTRING(dbo.Customer.FirstName, 1, 100) AS FirstName, 
  dbo.Customer.LastName, dbo.Customer.Gender, 
  dbo.Customer.DateOfBirth, dbo.Address.Zip, dbo.Customer.CustomerID, dbo.Customer.IsRegistered
  FROM         
  dbo.Customer INNER JOIN
  dbo.Address ON dbo.Customer.CustomerID = dbo.Address.CustomerID
  </code></pre>
  
  <p>What other fixes should I put in place to ensure the package runs without error?</p>