Hi. New to SSIS. I have an SSIS package. It runs and loads data from an Access db to a SQL server db.
The package is currently working but I would like it to check a flag in a table for a 1 or 0 at the start to see if it should continue. If not I'd like to go to an alternate path. Just basic logic.
I thought maybe I could load the flag value into a variable but I can't figure out how. Does anyone have any ideas. I've been hitting my head against the wall for a day now. Can't believe I can't see a way to do what should be a really simple task. I can think of some really ugly ways to do it but I'd like to see what other people are using before I delve into that nightmare.