IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005

Discussion in 'microsoft.public.sqlserver.dts' started by M. Ranft, Aug 25, 2008.

  1. M. Ranft

    M. Ranft Guest

    Hallo,

    I have a very urgend problem. There is an Oracle database which contains
    hundreds of tables and each contain over thousand rows. I need to import
    these data from Oracle to MS SQL-Server 2005. All I get is error messages!
    (I didn't post them here, because the most important part would be: How do I
    get them in the database ... the datatype that should be used,
    VARBINARY(MAX) is not available during the "import data"-dialog.

    I need urgend help. If anybody can help me, please answer to this.

    Thanks in advance

    Manuel
     
    M. Ranft, Aug 25, 2008
    #1
    1. Advertisements

  2. M. Ranft

    gina rami Guest

    Hi Manuel, i've your same problem... now, one year after i really hope you've found a solution: can you explain it please?
    Thanks




    M. Ranft wrote:

    IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005
    25-Aug-08

    Hallo

    I have a very urgend problem. There is an Oracle database which contains
    hundreds of tables and each contain over thousand rows. I need to import
    these data from Oracle to MS SQL-Server 2005. All I get is error messages!
    (I didn't post them here, because the most important part would be: How do I
    get them in the database ... the datatype that should be used,
    VARBINARY(MAX) is not available during the "import data"-dialog

    I need urgend help. If anybody can help me, please answer to this

    Thanks in advanc

    Manuel

    Previous Posts In This Thread:

    IMPORTING BLOB-COLUMN FROM EXISTING ORACLE-DB IN SQL-SERVER 2005
    Hallo

    I have a very urgend problem. There is an Oracle database which contains
    hundreds of tables and each contain over thousand rows. I need to import
    these data from Oracle to MS SQL-Server 2005. All I get is error messages!
    (I didn't post them here, because the most important part would be: How do I
    get them in the database ... the datatype that should be used,
    VARBINARY(MAX) is not available during the "import data"-dialog

    I need urgend help. If anybody can help me, please answer to this

    Thanks in advanc

    Manuel


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    Scrolling in WPF Toolkit?s Column Chart
    http://www.eggheadcafe.com/tutorial...6/scrolling-in-wpf-toolkits-column-chart.aspx
     
    gina rami, Jul 30, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.