Post reply

SQL Server 2005 - How do I import data from an Oracle Data Pump file?

  • July 9, 2007 at 4:04 am

    #173438

    All,

    Subject: SQL Server 2005 - How do I import data from an Oracle Data Pump file?

    Tried looking in the SQL help for this and it's not very forthcoming on how

    you do this.

    How do I achieve this? Can someone send me an example SSIS package OR tell

    me the steps OR point me towards a resource that could help me?

    Look forward to your replies.

    Many thanks,

    Regards,

    Richard.

  • July 9, 2007 at 4:13 am

    #717962

    You can use the import/export wizard available with SSIS to migrate data from ORACLE to SQL Server. You need to create a ODBC pointing to the ORACLE database and use it as connection property.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 9, 2007 at 4:18 am

    #717965

    I presume then I can point SSIS or Import direct to a Oracle Pump flat file?

     

  • July 9, 2007 at 5:05 am

    #717977

    You can use the wizard to say which is your source adn the destination and choose oracle ODBC as your destination to move data there.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 4 posts - 1 through 3 (of 3 total)

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