Yes all files extension is .dbf only,i have same version only and i have verified with III and IV and II also but no result same error. I am able to open and see the content of all files using the Microsoft VisualFoxPro tool.

Hi I have some dbf files i want to load these dbf files into SQL server db tables. I have created one SSIS package. Its working fine for some dbf files,but not working for some other dbf files. But I have checked in java , in java its working fine all dbf files. I don't know whats the reason SSIS is not working for all files. I have created the connection manager for dbf as like below Drive:Mcrosoft Jet 4.0 OLE DB provider. Path : upto root folder of dbf file("F:\PIHTask\Temp\") Extended properties:dbase 5.0 I am using same connection for all dbf files,but in dataflow task the OLEDB source is able to open only few files ,but not all. File extension is same for all file like *.dbf. I am new to SSIS,Please help me to resolve this issue.

first : what error do you receive on other files? second: SSIS data flow doesn't support dynamic metadata, does all dbf files have same structure? same columns? same data types? third : I can't understand what do you mean by "checking in java" !http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

I am not running the package, When i am doing designing package I think OLE DB source task we can able to see the columns and preview data by selectig the table or view and select the DBF file. Its showing the data for some files but its not showing for other files. its throwing the error as : 1. An OLE DB error occured.Error code:0X80004005 2. Opening a rowset for "ItmStore" failed.Check the object exists in database. 3. Additional Information: Exception from HRESULT:0XC02020E8. In Java also we can able to load the data from DBF file into table using some other drivers.But comparitively SSIS is best.

What SQL server version you are using? Check this link, are you able to do this: http://msdn.microsoft.com/en-us/library/aa337084.aspx ~manoj | email: http://scr.im/m22g http://sqlwithmanoj.wordpress.com MCCA 2011

SQL server 2005. I have followed the same steps which are mentioned in that link. I am able to open some files but not all.

Do all the files have DBF extension and of same version, here 5.0 ? Verify this. Check if they are not corrupted.~manoj | email: http://scr.im/m22g http://sqlwithmanoj.wordpress.com MCCA 2011