Tag Archives: ssis

The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine

This short blog show you how to resolve the error “The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.” when you are using SQL Server Management Studio 2016 to import an Excel file. What you need to do is … Continue reading

Posted in .Net, Community, Computers and Internet | Tagged , , , , | Leave a comment

Script Component Transformation in SSIS

This article shows you how to use Script Component in SSIS to transform a database column. Assumption: You have at least Visual Studio 2013 with SQL Server Data Tool installed. Scenario: Appending a “1” in all the product number and … Continue reading

Posted in .Net, Community, Computers and Internet | Tagged , , , , , | Leave a comment