Connect to dBase file via SSIS

I was tasked to convert a dbase application to a web apps. The first step is to pull data from dBase

 

1. In Connection Managers, New a OLE DB connection by using Microsoft Jet 4.0 OLE DB provider

 

2. On the Server name,  it’s a little bit tricky as you have to put the path instead of the file name. (I got stuck on this part for a few hours!)

 

3. In All property, manually enter dBase II in the Extended Properties ( MS said that, not me!)

 

Test the connection and there you go!

 

Another way is the pull data and dump into an Access table or excel sheet. However, by using SSIS, you can have more flexibility during the ETL process.

 

 

Here is the link from Microsoft on how to connect to dbase or other DBF file

 

http://msdn.microsoft.com/en-us/library/aa337084.aspx