Microsoft BI SSIS Series-Import data from an ACCESS database in SSIS

Introduction to the outset

From Tian Shan College A student's question, how to import data from an ACCESS datasheet in SSIS.

Import ACCESS database data in SSIS

Access is actually a lightweight desktop database that is stored directly in the form of files. There is not much use of access as a BI data source in the country, but it is more used abroad, especially in the United States, because their IT base starts early. In my first American health insurance project, I encountered a large number of access data sources, with a total of more than 500 access tables before and after. And now some friends from abroad to feedback the situation is still in use, so it is necessary to record this little knowledge point.

The following shows an import of access 2013 data tables in SQL Server 2012, open access 2013.

Create a new desktop database.

Create a new table and add some test data.

Create a new package and a data flow Task, the data source uses OLE DB source. Create a new Connection manager that uses Microsoft Office 12.0 access Database Engine OLE DB Provider.

PS: Refer to Microsoft BI's SSIS Series-Access Excel 2013 via OLE DB Connection and download and install this driver for data processing on different Sheet pages.

Copy the ACCESS database file address directly, and if you don't have a password, you can provide blank Password password.

The subsequent use of the same process as normal SQL Server data import-Specify the database, the data table source.

Preview the data.

Use OLE DB Destination.

Specify the target database and the target table.

Mapping.

Save and execute the package, and the data flow executes the result.

View test Data Sheet results.

For more bi articles, see the Bi-series essay list (SSIS, SSRS, SSAS, MDX, SQL Server) If you feel this article has helped you, please help recommend it to make it easy for others to see these articles quickly in the Biwork blog recommendations Bar.

Microsoft BI SSIS Series-Import data from an ACCESS database in SSIS