Process results of conditional split in SSIS
- by Robert
I have a Data Flow Task and am connecting to a database via an OLE DB Source component to extract data. This data feeds into a Conditional Split component to separate the data based on a simple expression.
After the evaluation of this expression, the data will end up in either of two locations: LocationA or LocationB.
Alright, I have that all set up and working properly. Once the data is separated into these two locations, additional processing is to be done on the records.
Here's where I am stuck: I need the the processing of records in LocationA to occur before the processing of records in LocationB.
Is there a way to set precedence of which tasks occur before others? If not, what is the best way to handle this? I was thinking I may need to write the data in LocationA and LocationB back out to the database and create a new data flow task in the control flow to handle the order of which these records must be dealt with.
Any help is greatly appreciated!