Home Forums Data Warehousing Integration Services How to create a Connection Manager to access directly to a PROGRESS DB RE: How to create a Connection Manager to access directly to a PROGRESS DB

  • I connect to a progress database (10.1c version)

    We installed the odbc driver and connect to Progress via SSIS to import data into SQL

    this is how I use it in SQL 2005

    in a ssis package connection manager pane > right click> new connection

    in "Add SSIS Connection manager" window select type "ODBC"

    in "Configure ODBC connection Manager" > select New

    in "Connection Manager" select your installed ODBC driver enter the login/pwd info >test connection

    Alternatively in the "connection manager" window you can "use connection string"

    this will be something like this

    Dsn="WhatyoucalledtheDSN"={Progress OpenEdge 10.1C Driver};uid=administrator;host="yourservername";db="yourprogressdbname";port="yourProgressportnumber"

    hopefully this may help you

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day