SqlServer Begin's

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 C