Unanswered: SSIS: Combine and Control Direction of Flow
I am still an SSIS newbie, so bear with me.
I have two functional SSIS packages which are very simple. The first pulls data from a SQL db (via sproc) and stores it in a flat file. The second grabs that flat file and imports it into a second db with an identical table to the first db.
I want to combine these packages into one package, and then control which 'section' (Import or Export) of the package is used with a flag of some kind. Ultimately this will be run from an agent job.
I have explored a few things but it seems like there are a lot of options for this, so I wanted to get some opinions on what you use / how you do it.