Post reply

Extracting Data from Compressed CLOB XML using SSIS

  • April 14, 2014 at 4:15 am

    #285694

    Hi

    Source System : Oracle

    Target System : Ms Sql Server 2012

    ETL Tool Used : SSIS

    My source data is present in XML File which is stored in CLOB column Of Oracle. CLOB column is compressed.I need to Migrate data by Uncompressing XML to SQL 2012 .

    Do I need to define XML column in SQL Server 2012 for storing Uncompressed CLOB values ?

    I am confused about the approach to follow Request you to help mw out on how to uncompress the clob and

    extract the required data from XML using SSIS .

  • April 15, 2014 at 3:06 am

    #1706018

    Hi

    please suggest approach for the scenario

    Thanks

  • April 15, 2014 at 4:09 am

    #1706025

    About uncompressing the CLOB: you should talk about your Oracle admins on how to do that.

    Regarding storing the XML: I would store it in a VARCHAR(MAX). If you use XML, SQL Server will validate it before inserting it in the table and this can impact performance a lot.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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