paradox to sql server 2005

Hi,
I have been told, I will have to transfer some paradox data into sql server 2005.
What is the best way to do this? i.e. if SSIS can be used, then what will be the source? I ask because there does not seem to be a source for Paradox.
Any thoughts please?
ThanksParadox came with an ODBC driver. Install the driver and use that as your source.|||

Do you mean in the DataFlow sources there should be ODBC sources? If so, how do I get it to appear there? Do I need to install ODBC driver first? where do I get it from please?

Thanks

|||

arkiboys wrote:

Do you mean in the DataFlow sources there should be ODBC sources? If so, how do I get it to appear there? Do I need to install ODBC driver first? where do I get it from please?

Thanks

Please reread Tom's post. If you can connect to Paradox, you should already have th ODBC driver loaded. Using a DataReader Source in your Data Flow, you should be able to see the Paradox ODBC driver listed as an option for you. If you don't then you need to work with the vendor of Paradox to get the ODBC driver.