Link to home
Start Free TrialLog in
Avatar of stopher2475
stopher2475Flag for United States of America

asked on

SSIS Check Data Load

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.
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stopher2475

ASKER

Perfect. Tested it out and I'm in business.
Thanks!
Chris
Thanks for the grade.  Good luck with your project.  -Jim