SQL Server Performance

SQL Server 2005 - How do I import data from an Ora

Discussion in 'SQL Server 2005 Integration Services' started by rmsterling, Jul 9, 2007.

  1. rmsterling New Member

    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.
    rmsterling, Jul 9, 2007
    #2

  2. satya Moderator

    Where did you looked, I believe there is a topic available in updated SQL 2005 books online such as HOW DO I topics.

    If this is a one-off requirement then you can take help of SSMA for Oracle,http://sqlug.be/blogs/por_dentro_sql/archive/2006/10/24/379.aspx fyi. Alsohttp://msdn2.microsoft.com/en-us/library/bb332055.aspx on more with topic .

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 9, 2007
    #2

  3. rmsterling New Member

    Thank you for your help. I will read these articles and let you know how I get on.

    Regards,
    Richard.
    rmsterling, Jul 9, 2007
    #2

Share This Page