Data flow task, flow going to success as well as failure simultaneously from flat file source

• Sumit Rastogi

  SSC Eights!

  Points: 838

  More actions

  June 3, 2015 at 6:06 am

  #297434

  Hi,

  In my package I have Flat File Source(reading .dat file), that needs to be insert/update table at sql destination, the FlatFileSource have 2 output: 1 for success and 1 for failure.

  For SUCCESS, I am doing some transformation, derived columns, lookup to check existing data then conditional split, then update existing records and insert new records --> WORKING FINE.

  For FAILURE(Redirect Row on Error and Ignore on Truncation), I am moving the file to another directory --> ALSO WORKING FINE.

  But the problem is --> ALL the Files are going simultaneously to SUCCESS as well as FAILURE component (do not showing any error details).

  Please help!

  Thanks,

  Sumit Rastogi