Connecting to Paradox tables

[VE]

I followed the instructions in thread1555-1278687, which got me to a point were I could actually see the table names in the OLEDB source editor.

But if I try to preview, or create a query I get an error that says that there are no column names.

The machine that has SSIS installed does not have BDE, which I'm really hoping is not the issue.

If it is BDE, does anyone know of a work around?

I probably won't be able to install BDE on this server, the app that needs it conflicts with other things. Would I be able to install just SSIS and no other components on the server that does have BDE?

Thank you for your help.

 

[VE]

Just in case anyone else has to connect to a legacy paradox system like this...

BDE does need to be installed and configured on the machine that runs the package.

Follow the instructions in the thread I referenced above.

Set Run64BitRunTime for the project to false.

Yay...