In this post, we will learn how to load the MS access database table to SQL server or other destination using SSIS.
Taking the data flow task.
Double click on the data flow task.
Here I am taking source as OLEDB source.
Now we need to create a connection manager.
Creating a new connection.
Select Provider as Microsoft office 12.0 Access Database Engine OLEDB Provider
Click ok.
Write the MS Access Database path.
Click on the test connection.
Click ok.
We will get the list to tables which are in the Access database.
We will see the column
Click ok.
Now I am taking destination as OLEDB.
Map the source and destination column
Click ok.
Now the package is ready to run.
Before running this package records in the table.
MS Access records
Now I am running this package.
Package executed successfully
.
See the records in the table.
