SSIS dBASE IV OLEDB source error

1
votes

The package that I am working on moves data from a .DBF file onto a table on SQL server.

I used provider for the source as Microsoft Jet 4.0 OLE DB Provider and set extended properties in the all tab of the connection manager to "dBASE IV". (which is required for .DBF files - pulled this information while building package)

enter image description here

enter image description here

I have given environments - DEV, QA and PROD and have created project parameters to access respective paths.

For the source, went into properties and gave an expression to pick up filepath for respective servers (DEV, QA and PROD) and ran into below error while running the package.

The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.

enter image description here

Any help is much appreciated.

1
sql-serverssisoledbetldbase

1 Answers

1
votes

Based on this article, the DBF connection string is like the following:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;

You have to specify the folder that contains the database not the .DBF file

Additional Information