compare multiple files and write

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  June 21, 2017 at 1:45 pm

  #337687

  I have 1 input files, which has 5 fields,

  now 1 field I need to compare with file1, 2 with file3 and remaining with file 3.

  if all r match , I need to write that record to table(in oracle) .if not I need to write those records in excp files,

  how to do in ssis, I don't know about script task how to open files and read fields in c#.

  thanks

• bradwilliams51

  SSC-Addicted

  Points: 444

  More actions

  September 19, 2017 at 10:00 am

  #1959987

  Use a Lookup Transformation or a Merge Join (data will need to be sorted), if you can provide more information I can have a look for you.