Connect to a dBASE or Other DBF File
Applies To: SQL Server 2016
You can connect to a dBASE or other .DBF database file in an Integration Services package by using an OLE DB connection manager and selecting the Microsoft OLE DB Provider for Jet 4.0.
Add a new OLE DB connection manager to the package. For more information, see Add, Delete, or Share a Connection Manager in a Package.
On the Connection page of the Connection Manager dialog box, select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider as the Provider.
When working with DBF files, the folder represents the database, and the individual DBF files represent tables. Therefore the Database file name text box must contain the path of the folder where the DBF file resides, and must not include the file name itself. You can type or paste in a folder path, or you can use the Browse button to select your DBF file, and then remove the file name from the end of the folder path.
On the All page of the Connection Manager dialog box, enter dBASE III, dBASE IV, or dBASE 5.0, as appropriate, as the value of Extended Properties.
Click Test Connection to validate the values that you have entered. You should see the message, "Test connection succeeded." Click OK to close the message box.
Click OK to save the configuration for the connection manager.
To use your connection manager in the data flow of the package, select an OLE DB source or destination and configure it to use the connection manager that you created by using the preceding steps.