Import .dbf files in sql server 2005

• rocks

  SSC Eights!

  Points: 988

  More actions

  October 11, 2011 at 4:25 pm

  #1393189

  Did you get any solution for this , as i got the same error.

• skumar02582

  SSC Enthusiast

  Points: 123

  More actions

  November 28, 2012 at 7:34 am

  #1563149

  Hi Dhan,

  I am getting below error when tried to preview the dbf table in BIDS

  Error at Meta file [OLE DB Source [413]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  Error at Meta file [OLE DB Source [413]]: Opening a rowset for "FIN2007" failed. Check that the object exists in the database.

  please suggest

• skumar02582

  SSC Enthusiast

  Points: 123

  More actions

  November 28, 2012 at 7:49 am

  #1563159

  Hi Dhan,

  i got below error when tried to import .dbf file through SSIS package when clicked on preview button after selecting the name of dbf table.

  Error at Meta file [OLE DB Source [413]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  Error at Meta file [OLE DB Source [413]]: Opening a rowset for "FIN2007" failed. Check that the object exists in the database.

  please suggest

• skumar02582

  SSC Enthusiast

  Points: 123

  More actions

  November 28, 2012 at 7:51 am

  #1563164

  Dhans (2/11/2009)

  ---

  I am sorry, I have no Idea of linking SQL Table to DBF file.

  Dhans:unsure:

  Hi Dhan,

  i got below error when tried to import .dbf file through SSIS package when clicked on preview button after selecting the name of dbf table.

  Error at Meta file [OLE DB Source [413]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  Error at Meta file [OLE DB Source [413]]: Opening a rowset for "FIN2007" failed. Check that the object exists in the database.