Progress DB to SQL DB

cotton31 · 11 Sep 2009 at 16:31

Hi,

I am trying to import data from a Progress database into a SQL database, using SQL Server Integration Services.

I am using SQL Server 2005.

Does anybody have any experience of doing this, or any websites that could point me in the right direction?

Cheers,
Matt

Pho · 11 Sep 2009 at 19:19

Can you post the structure of your data and/or some samples of it?

cotton31 · 11 Sep 2009 at 20:30

I don't have any examples to give unfortunately - why is this required?

Maybe I worded my question wrongly - I haven't hit problems anywhere as I haven't actually started the process yet. I just know that it is possible and I want to know how I would go about it.

cotton31 · 13 Sep 2009 at 12:51

Anyone?

Pho · 13 Sep 2009 at 14:58

Sorry, I thought for some reason you meant excel or the like.

http://www.progresstalk.com/showthread.php?t=96440 maybe?

Looks like you can use these ODBC drivers to connect SQL Server to the progress database:
http://www.datadirect.com/solutions/relational-databases/sql-server/index.ssp

edit: infact I'd imagine you'd find what you're looking for somewhere else on that site if not.