none
Progress Database to SqlServer - using ODBC linked Server

    Question

  • 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 ??

    Regards

    Sailash

    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

    Onur

     


    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.

    Visit: ssisnedir.com/blog


    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