Error reading DBF file in SSIS

Question

Post reply

Error reading DBF file in SSIS

Panks-913490

SSCrazy

Points: 2131
More actions
April 16, 2009 at 1:37 am

#129402

I am trying to import a DBF file into SQL server using SSIS.
I am using the method describle in the link
http://timothychenallen.blogspot.com/2007/07/how-to-import-dbase-tables-into-sql.html
I have created a OLEDB connection manager for this but it is unable to read the file and gives the error:
Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
Error at Data Flow Task [OLE DB Source [1]]: Opening a rowset for "AssetDBF" failed. Check that the object exists in the database.
Can some one help here?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

dave-0 Mr or Mrs. 500 Points: 550 More actions · Answer 1

It might be a different type of DBF file

i.e try dBASE III or dBASE IV instead of a dBASE 5.0

hope that helps

Phil Parkin SSC Guru Points: 246985 More actions · Answer 2

Or Visual Foxpro, for which another (free) driver is almost certainly required.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Panks-913490 SSCrazy Points: 2131 More actions · Answer 3

i have dbase III and IV but it doest work..

wat about visual foxpro... how to get its free driver?

dave-0 Mr or Mrs. 500 Points: 550 More actions · Answer 4

In the instructions:

Click the "All" button, scroll up to Extended Properties, and put in "dbase 5.0". If you don't do this, SSIS will try to read your dBase file as an Access file, which will fail. While you're here, you can hit "Test Connection" and it should work.

Instead of dbase 5.0 did you try dbaseIII or dbaseIV?

Phil Parkin SSC Guru Points: 246985 More actions · Answer 5

Panks (4/16/2009)
i have dbase III and IV but it doest work..
wat about visual foxpro... how to get its free driver?

Check out this thread:

http://www.sqlservercentral.com/Forums/Topic285021-146-1.aspx

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Panks-913490 SSCrazy Points: 2131 More actions · Answer 6

I have tried both dbase III and IV but they dont work.

The problem is i am not a DBA, just a developer. So i can't

download and install just any driver from the net.

Are there any workarounds?

I also tried using the below script:

SELECT * FROM OPENROWSET(

'MSDASQL',

'Driver={Microsoft dBase Driver (*.dbf)};DBQ=K:\Dundee\PSALM\',

'Select * from DBFTableName')

but i get the below error:

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server.

Again a showstopper as i am not the admin here. Is there anything a petty user bereft of all the admin priveliges can do here. 😛

Can some one show the way?

Phil Parkin SSC Guru Points: 246985 More actions · Answer 7

Panks (4/16/2009)
I have tried both dbase III and IV but they dont work.
The problem is i am not a DBA, just a developer. So i can't
download and install just any driver from the net.
...

This is not just "any driver," it is "the driver." If your database is V Foxpro (and surely you, as a developer, should know, or be able to find out, what sort of database you are dealing with), it seems like a perfectly legitimate request for you to say: "I need the V Foxpro driver installed please."

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Panks-913490 SSCrazy Points: 2131 More actions · Answer 8

Phil,

Thanks for your help.

Just got the answer to my question from the user. Its a Visual FoxPro file.

So it cant be imported without a driver installed?

Just wanted to sure before i raise a request (which will go through my boss)

thanks..

johndempsey SSC Journeyman Points: 95 More actions · Answer 9

Panks-913490 (4/16/2009)
I am trying to import a DBF file into SQL server using SSIS.
I am using the method describle in the link
http://timothychenallen.blogspot.com/2007/07/how-to-import-dbase-tables-into-sql.html
I have created a OLEDB connection manager for this but it is unable to read the file and gives the error:
Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
Error at Data Flow Task [OLE DB Source [1]]: Opening a rowset for "AssetDBF" failed. Check that the object exists in the database.
Can some one help here?

DBF databases can be repaired due to recover foxpro. It owns high end, easy to use interface for any experienced user. The program is able to work under any Windows OS. The software doesn't modify source data during restoration.