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 ...
This blog is to, share the encounters and learning’s of Sql Server