title: Error debugging SSIS (excel source, data conversion, OLE DB destination)
body: <p>I am having issues creating a good data flow from Excel Source to SQL DB in BIDS 2010. I'm using 32-bit runtime, i have windows authentication on the SQL Server. I'm trying to send the data to a table that has no relationships or constraints at all. My excel file is .xls and I've tried doing this to SS2012 and SS2008R2 databases, getting the same errors back.</p>
  
  <p>Here's my Package Validation Error:</p>
  
  <pre><code>Error at Data Flow Component [SSIS.Pipeline]: "component "Source for Excel Connection Manager" (1)" failed validation and returned validation status "VS_ISBROKEN".
  
  Error at Data Flow Component [SSIS.Pipeline]: One or more component failed validation.
  
  Error at Data Flow Component: There were errors during task validation.
  </code></pre>
  
  <p>(Microsoft.DataTransformationServices.VsIntegration)</p>