I am not able to see Microsoft Office 12.0 Access Database Engine Oledb provider in SSIS and I'm using MS Office 2013.
How to re-solve this?
You are missing the Microsoft Access Database Engine 2010.
Download it here: https://www.microsoft.com/en-US/download/details.aspx?id=13255
Install it on your dev-client and on your servers. After the installation has completed, you should see the Microsoft Office 12.0 Access Database Engine OLEDB provider in your Visual Studio's connection wizard.