arkiboys


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
Thanks



Re: paradox to sql server 2005

Tom Phillips


Paradox came with an ODBC driver. Install the driver and use that as your source.






Re: paradox to sql server 2005

arkiboys

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






Re: paradox to sql server 2005

Phil Brammer

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.