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

  • If you are using an ODBC connection then it will be an ADO.NET Connection Manager and ADO.NET Source in SSIS. I am assuming you were not able to located a suitable OLE DB driver for this particular database type.

    I just did a quick google for this platform and it appears they do have one. If this is the same product you are working with I would suggest using that since OLE DB is more native less buggy in SSIS and SRSS.

    http://www.datadirect.com/products/other/ole-db-provider/index.html

    Hope this helps!

    Eric