We used to use DTS to read Paradox files. This is something we do regularly. DTS has a native Paradox driver. This seems to have disappeared in SSIS.
Can anyone recommend the best way to read Paradox Files with SSIS?
Click New OLE DB connection. Choose "Native OLE DB\Microsoft Jet 4.0 OLE DB Provider". On the "All" tab find "Extended properties" and type "Paradox 5.x". For the "Data source" type the directory where your tables are.|||Great, that helps. Is there a way to add such a connection to the SSIS Wizard? (DTSWizard.exe)
|||thanks a million Bog !
No comments:
Post a Comment