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