Gotcha-yours When Working With XLSX In SSIS

I encountered many challenges during the last one and half weeks with my first commercially billable SSIS work. Following are few of the Gotcha-yours

-          The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

When                    -  Encountered  this error when importing data from “XLSX” to OLEDB component

Component            – “Excel Source Editor”

Fix                        -   Download and  install AccessDatabaseEngine.exe

                                     http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23734

Note      
Without this driver the excel file is will not be read 100% , in other words the "Excel source Editor" component completes but does not scan through the entire file.

-          Index and length must refer to a location within the string.Parameter name: length (mscorlib)

When                    - Attempting to view the excel data from the work sheet

Component           - in the preview of “Excel Source Editor” component

Fix                        - Changing the name of the work sheet to not have a prefix with numeric

-          IF the package is to do with Excel you need to finalize if the “Run64bitRuntime” needs to be disabled

When                    - If the package is built on 64 bit this will be set by default to True, But excel does not seem to have the required drivers for 64 bit