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 9, 2014 at 9:32 pm

    #1687421

    Hi,

    Actually i have 10 files which have 30 columns common in all files,but some files having additional colums that may be 10 columns only ,but i have this 40 columns in my destination table so i want to load this all files in single package.And if it is possible with script component please send code.i think it is clear now ..common colums in all files like this id,dealer name,addderes,............. and additional columns in file 1 is agent,sales no,and additional column in file 2 is product,..and in final destination table columns are id,dealer name,adderess,agent,sales no,product,(this table is having all columns).