Post reply

Extracting data from Progress database using SSIS

  • December 8, 2006 at 1:31 pm

    #115598

    I'm having a problem extracing data from Progress database into sql server 2005 Enterprise Ed using SSIS.

    I cannot go past congifuring the Connection manager/Data flow source to correctly connect to Progress Database.

    I'm using OpenLink Lite for Progress 9.1b drivers.

    This works fine with DTS on SQL Server 2000 Enterprise.

    Any Help or Suggestion is welcome.

    Thank you

    JM   

  • December 8, 2006 at 1:42 pm

    #677041

    I went through this same, painful process.

    Here's what I used:

    Driver:

    MERANT 3.60 32-BIT Progress SQL92 v9.1D

    Connection String:

    Driver={MERANT 3.60 32-BIT Progress SQL92 v9.1D};uid=username;password=password;databasename=dbname;portnumber=1234;hostname=123.456.789.101

    In your data flow tasks, configure the connections to PROGRESS as OLEDB sources. Try different combinations for your SQL string as PROGRESS interprets the queries slightly... different.

    I tried several different combinations before I got that one to work. Good luck...

  • December 8, 2006 at 1:58 pm

    #677045

    Thank you Aaron. I will try the Merant drivers.

    Did you ever try the Openlink Lite Drivers?

     

  • December 8, 2006 at 2:07 pm

    #677047

    I honestly don't recall. I remember I tried the DataDirect drivers as well as the 3.7 version of the Merant drivers with no success.

  • December 8, 2006 at 2:26 pm

    #677054

    Thanks Aaron

  • April 23, 2008 at 7:36 am

    #806047

    where do you get the drivers for connecting to a progress db?

  • April 28, 2008 at 9:43 am

    #807902

    Hey guys I have a small project due for my work that requires converting tables from Progress into SQL 2005 and need

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply