Execute Data Flow Task based on condition in SSIS

Question

I am very new to SSIS and I am building a package which will import files. I have a Execute SQL Task which will execute a SQL statement which will return files that needs to be imported, but the files will need to go into different tables depending on which file is being imported.

I have 2 Data Flow Tasks in my foreach container but now based on the file type it needs to execute 1 of them

How can I achieve this?

enter image description here

EDIT

This is the query that will be executed:

SELECT ReconMedicalAidFile.fReconMedicalAidFileID,   ReconMedicalAidFile.fReconMedicalAidID, 
ReconMedicalAids.fMedicalAidID, ReconMedicalAidFile.fFileName, 
ReconMedicalAidFile.fFileLocation, ReconMedicalAidFile.fFileImportedDate, ReconMedicalAidFile.fNumberRecords, ReconMedicalAidFile.fUser, 
ReconMedicalAidFile.fIsImported
FROM ReconMedicalAidFile INNER JOIN
ReconMedicalAids ON ReconMedicalAidFile.fReconMedicalAidID = ReconMedicalAids.fReconMedicalAidID
WHERE (fIsImported = 0) AND (fNumberRecords = 0)

So the condition is based on fMedicalAidID

I assume you have multiple files, hence the ForEach loop. How are the file types recognized? By the extension? — Raj
I have a flag column in my table which will indicate which file is which — Gericke

Eric Hauenstein Eric Hauenstein · Accepted Answer · 2015-06-17T12:55:32

The dummy script approach: DummyScript

In the expressions for the two precedence constraints you evaluate a variable that is set either by the first SQL task or the script task. enter image description here

Now, the data will flow down one of the two data flow paths based on the value of the variable. The script task can be empty, or it can perform the logic needed to set the variable.

Execute Data Flow Task based on condition in SSIS

2 Answers