locked
Import data from non relational database to relational database RRS feed

  • Question

  • Hi,

    I have a task to import data from non relational database to relational database.

    I need to check the constraints conditions  of all the columns and check whether it satisfies with new relational database and then only data need to be inserted.

    For example validations like foriegn keys, datatype match, no of charcters,etc

    Can u anyone give me small example how to do with ssis or any other method.

    Thanks In Advance.


    • Edited by A Sireesha Monday, January 20, 2014 9:38 AM
    Monday, January 20, 2014 9:37 AM

Answers

  • I think it depends on the input source format and destination table format i.e master/transactional tables and relations. For instance we can use conditional split task to split the input columns and save to different destination tables. We can also manipulate or derived an input column base on our need. String functions can be used in the expressions to manipulate input strings. We can also use script task if needed.

    Regards, RSingh




    • Proposed as answer by Mike Yin Thursday, January 23, 2014 8:08 AM
    • Edited by Ch. Rajen Singh Thursday, January 23, 2014 2:22 PM
    • Marked as answer by Mike Yin Sunday, February 2, 2014 1:46 PM
    Monday, January 20, 2014 11:17 AM