Thanks Chuck. I have tried using a tool for generating sql script and found that there is issue with data types and data .

Hi, I am trying to convert paradox db files to SQL server using SSIS. For most of the files it works fine but for few I have the following Error : TITLE: Microsoft Visual Studio ------------------------------ Error at EMPLOYER SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Error at EMPLOYER Opening a rowset for "EMPLOYER" failed. Check that the object exists in the database. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ Please suggest for resolving this error. Thanks, JR

Obvious question - is there a table called employer? And is your database case sensative (Employer vs employer)Chuck

Chuck, I just gave an example as Employer. I am directly using the paradox db filename as tablename. Thanks, JR

OK - when you set up a datasource pointing at paradox can you select the table you are interested in from the tablelist?Chuck

Yes , I am able to see the list and also point it to that table,but when I go to columns tab or preview tab I see this error.

Are there table level permissions set that would not allow you to select from the table?Chuck

Similiar paradox issue http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fc9bb3e5-5af2-4614-bca0-b3408479306e/Chuck

I am able to do import data for other db files, only some of them have issue like these.

Thanks Chuck. I have tried using a tool for generating sql script and found that there is issue with data types and data .