Loading MS Access database to sql server table using SSIS

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.