Skip to main content

Posts

Showing posts from August, 2012

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                                     ...