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