Recent content by stephenkelley

http://www.hawthorneblog.com/node/5287 has screenshots to illustrate the 3 steps

Here's how I got around this limitation: 1. create a ODBC connection to the Progress database 2. add this ODBC connection as a linked server in SQL 3. set the security option for the linked sever to "be made using this security context" which lets you specify the username/password to use Let...

I can run a table import manually from OpenEdge to SQL in SQL 2005 using the Openedge 10.1A ODBC driver with no problem. I save this as an SSIS package. However, when I try to run this package, it always fails. I suspect the problem is that the password is not saved in the ODBC connection...