bobd125 (12/6/2012)
So ignore the Derived Column and just used "((DT_I8)DETAIL_REC_CNT == (DT_I8)[INT_SENT-REC-SNT] ? TRUE : FALSE " is the Conditional Split. And how do I set the Error Output, or default path?. I would like to have the DataFlow stop with an error.
As I alluded in my previous message, there is a fundamental problem with trying to do this all in a data flow. Data flow transformations occur for every row, as they pass through the pipeline.
How can you put a conditional split on row 1 of the data, when you do not yet know the total number of rows in the trailer?
Derived columns are similarly afflicted.
You need a way of reading all rows and doing the check before the rows go anywhere important. That is why I suggested an initial import to a staging table.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.