Flag point check for each task- SSIS

Hi experts,
I have a package which has numerous tasks and I was suggested if I can do a flag point check which means the following:
I need to create a final driver table(dbo.driver_task) which has flags yes/no for each step. The flag for each step/task will be
turned on if that task runs successfully("yes" in this case)
Lets say in total there are 5 tasks, for example the first two tasks(FTP, Data flow task) runs successfully and the third task-execute sql task fails, the table- dbo.driver_task should show:

select * from dbo.driver_task

Task_name    SuccessFlag
FTP task           yes
DF Task1          yes
Exec SQL task   no
DF Task2           no
DF Task3           no

Even though the DF Task2 and DF TAsk3 wouldnt run as the package failed at Exec SQL task, they should how that the success flag is 'no'......pls suggest how I can achieve this..thanks!
sqlcuriousAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tigin44Commented:
you should add Execute SQL Task to the very begining and after each step to set the table rows depending on the steps executed.
At the very beginning set all the steps to "NO" in your case and after each step if the step succesful you will reach a new Execute SQL Task to update the reklated tasks value to set to "YES" .if the step fails the execution will not reach the script which let tthe step and the following steps status as "NO" .. I attached a basic outline as a picture...
SSIS.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sqlcuriousAuthor Commented:
thnks a lot!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.