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.
Microsoft AccessMicrosoft SQL ServerSSIS

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Horn

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
stopher2475

Perfect. Tested it out and I'm in business.
Thanks!
Chris
Jim Horn

Thanks for the grade.  Good luck with your project.  -Jim
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23