Process results of conditional split in SSIS

Question

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!

Answer 1

I assume you need the results of LocationA processing for the LocationB processing? I don't have a working implementation of this that I can show you, but conceptually you could do a merge or join of the result of LocationA processing with the input of LocationB, but not actually use the values in the output. This would force LocationA to complete before LocationB runs.