Home Forums Data Warehousing Integration Services multiple files with some columns are same and some columns are different but i have to load all this columns into single columns how RE: multiple files with some columns are same and some columns are different but i have to load all this columns into single columns how

  • February 10, 2014 at 12:29 am

    #1687437

    And if it is possible with script component please send code ...

    It is possible, but I'm not going to write the code for you - unless you want to hire me as a consultant.

    Please take the time to do some research and have a go yourself. If you have specific implementation problems, feel free to post back and we will try to help.

    I can help with pseudo-code though:

    Foreach File

    Determine row format

    Foreach row

    Break row into columns based on row format

    Assign columns to output columns

    Next row

    Next File

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.