I have the Progress Database set up as a linked server.
I have created a new Integration Services project in Business Intelligence Development Studio and created a new ADO.net connection using an ODBC driver. I've chosen the database and given it some login credentials (I'm not sure what these should be - do OE database have the equivalent of a SQL SA user?)
I've then added a DataReader Source tool to the Data Flow tab and used my ADO.net connection, however when passing a query to it for it's SQL command I'm getting Autorization Errors.
[ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE] Access Denied (Authorization Failed)(7512)
Am I right so far, or should I be doing something differently?