Progress Database to SqlServer - using ODBC linked Server


  • Hi,

    I am using SSIS to transfer a Database from progress to Sql server.

    I am using OpenEdge 10.1B ODBC driver to connect to progress.

    Here Progress is Source and a Sqlserver is the destination

    I have created a Linked server from my Destination Sqlserver to the Progress Database.

    Now how can i Transfer the whole Progress Database to Sql server using SSIS.

    Can i user Transfer Database Task to import Progress DB to SQL Server.

    Please let me know how i can use the Linked server as my source ??



    Thursday, May 13, 2010 10:47 PM

All replies

  • Hi Sailash,

    Unfortunately, I think it is not possible to transfer the ProgressDB to SQL directly by using Transfer Database Task. But you can use SQL Server Import/Export wizard to import everything from Progress to SQL Server using ODBC driver.

    Hope that Helps



    BI and ERP Senior Consultant @ Nexum Bogazici
    If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.


    Will be presenting "Rapid Report Developing with SSRS 2008 R2 and ReportBuilder 3.0" on Microsoft Launch 2010; Istanbul - Turkey on May 18, 2010. Link
    Friday, May 14, 2010 12:14 AM