title: [OLE DB Source [963]] Error
body: <p>I have created a Data Flow Task containing an OLEDB Source and an OLEDB destination.  The OLEDB source has a data access mode of: SQL Command From Variable.  The variable is called: SQLQuery.  The design time value of SQLQuery is:</p>
  
  <pre><code>select '' as PersonNo from Person
  </code></pre>
  
  <p>The SSIS package is throwing the following error:</p>
  
  <pre><code>[OLE DB Source [963]] Error: The "output column "PersonNo" (1051)" failed because truncation occurred, and the truncation row disposition on "output column "Surname" (1051)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
  </code></pre>
  
  <p>I do not understand this error.  However, if I do the following it seems to work:</p>
  
  <p>select '1111111111' as PersonNo from Person</p>
  
  <p>Can I specify the length of PersonNo in the SQL Query?</p>