Hi Dhans, Thanks for the helpful post.
Is it possible to link my SQL table to the DBF file? My data is captured at the backend by a 3rd party app. I need to link to the app's files, and build the frontend from there.
Thanks again
Dhans (11/17/2008)
Instead of using Import/Export wizard, You can import DBF files using SSIS Packages.Steps:
1. Create an SSIS Package using BIDS.
2. In the Connection Managers
Right Click --> Create OLE DB Connection-->New--> In the Provider column, Select Microsoft Jet 4.0 OLE DB Provider--> Type the DBF file location in Database file name column.
for eg: C:\SSIS\DBFFiles\ (DO NOT TYPE THE DBF FILE NAME)
3. Press ALL button in left side --> Advanced-->Extended Properties Type : dbase 5.0 Press OK.
4. Now the Connection is created.
5. Create Destination SQL Server connection for storing the dbf data.
5. Drag the Data Flow task
6. In Data flow task, Drag OLE DB Source and OLEDB Destination tasks
7. In Ole Db Source, select the connection manager as newly created Dbase Connection.
8. Select your DBF File in Name of the table or View.
9. Connect OLE DB Source and OLE DB Destination and Map the Source and Destination Columns.
10. Run the Package..... thats all..