Error debugging SSIS (excel source, data conversion, OLE DB destination)

Question

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.

Here's my Package Validation Error:

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.

(Microsoft.DataTransformationServices.VsIntegration)

Solution

Please check at this URL, I have commented earlier today. BIDS Package Error's on Truncate while EXPORTING to flat file

Some suggestion as well:

1) Check the Data type in excel source. If the Source data type is different Convert or cast them as it is in Database.

2) Map the column correctly. Check if there are not null field in the destination.

3) Make sure you change the Project properties to RUN64bits to FALSE

Comments

[Nick.McDermaid]

Are you sure there aren't more detailed errors before this? Is the excel file on a local drive or remote? Does this error appear when running interactively in BIDS?

[Admin]

The only other errors had to do with data flow component, converting unicode to non-unicode, which i resolved already. The excel file is on a local drive, and I wasn't running interactively.

[Nick.McDermaid]

Can you 'preview' the source? Make sure the Excel file isn't already open in Excel.