Update records in Progress DB using SSIS


New Member

I have a Progress DB as an ODBC source which i export data from to allow transformation and then import into a SQL DB.
I would like to import cleansed data back into my Progress DB (update is most important but insert/delete could be useful too)

Does anyone have experience of doing this, or could suggest another way?



Well-Known Member
You did not provide the most important information: What version of Progress you are working with?

This is very important because the capabilities of the SQL engine have been enhanced dramatically over time. From totally unstable and unusable to stable and usable in recent versions of OpenEdge 11. You know Progress is NOT an SQL database in the first place and the SQL engine did evolve to the better over time.

Nevertheless, depending on what you are trying to achieve and what version of Progress you are working with you might wind up quite happy.