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 7, 2014 at 3:15 am

    #1686948

    ..load all this columns into single columns ...

    Please explain what you mean by this.

    In general, for every different file format, you will need a separate dataflow. Multiple files with the same format can use the same dataflow, often by using a FOREACH container to loop round those files.