I spent a few hours to find solution for my last project. I had to import data from old DBF files into SQL server. I made such things a few years ago with SQL server DTS, but In SQL server integration services (SSIS) it must be done in different way, but when you know how to do this, it’s simple. To create connection to DBF file you have to chose as a provider: “Native OLE DBMicrosoft Jet 4.0 OLE DB Provider” (screen below). Then you have to provide path to folder where your DBF files are located.
Then you have to go to options “ALL” and as “Extended properties” write “DBase 5.0” (next picture). And that’s all. When you create source or destination connection with this data source all DBF files stored in folder will be visable as single table (one file – one table).
[adblockingdetector id=”5770e6ed85560″]
