question

vish avatar image
vish asked

OLEDB connection is failing with DBF file as source.

I am trying to import .DBF file into SQL database but getting following error. //------------------------------------------------------------------- Error at Data Flow Task [OLE DB Source [6]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Error at Data Flow Task [OLE DB Source [6]]: Opening a rowset for "INVENTRY" failed. Check that the object exists in the database. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK //----------------------------------------------------------------------------- I am using OLEDB as source and destination component. Using Microsoft jet 4.0 oledb provider. Import is working for Excel file but not for dbf. Please help. Thanks -VJ
oledb
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
Does the .DBF file have a table named "INVENTRY"?
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
...or is it called "INVENTORY"?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.