SSIS Variables in Parent/Child Packages and Jobs

The real power of SSIS is variables and expressions. In an earlier video Marco introduced variables, in this lesson he talks about when you might want to override variables and how to do it - a great technique when you have parent/child packages, or you want to set the parameters to something you can control at the job level instead of inside the package.

From Portugal. 26 years old. Experience in a wide variety of business intelligence projects and industries (in particular communications, automotive, billing & payments, CRM). Currently working at the biggest Portuguese communications company as BI Architect, Performance/Tuning and Project Manadgement.

srinu on 8/11/2010

its beautiful but onething i want all tasks configuration

Terry Hoffman on 8/11/2010

volume on computer was maxed out and I still could not hear presentation.... speak up

bill on 8/11/2010

sorry, I didn't understand what he was trying to show

Rubens on 8/11/2010

Marco's SSIS videos are awesome, please keep them coming!

Leigh Anne on 8/11/2010

Informative. It would have helped to hear how this could be used in a real-world situation. I'm not sure I understand how to apply this in real life.

Thomas Kelley on 8/11/2010

Can you post your scripts (packages) so we can test locally?

Elaine Cormier on 8/11/2010

Excellent demo - it was thorough, used great examples that were easy to understand.

MohanD on 10/20/2010

Good

viquar on 10/21/2010

went too fast in showing the initial package configuration

Nitin on 2/3/2011

Simple and nice explanation.

jonh smith on 4/13/2011

This is much better than the first variable video. Really appreciated. Thanks!

NehalRana on 8/4/2011

little Fuzzy

Binod on 8/25/2011

thanks

Binod on 8/25/2011

thanks

Leigh Anne on 9/15/2011

It would be helpful to know how to use this in a real-life scenario. What types of variables would you override via scheduled job and how would that help?

pankaj on 9/18/2011

Nice explaination of creating job

T. Carnahan on 9/21/2011

A little too fast, but good. I will need to watch this several times.

Bhaumik Gandhi on 9/25/2011

This is really good

Maureen on 12/16/2011

I would have never known you can do this without this video, thank you!

douglas williams on 7/1/2012

Great info and demonstration.

learningsqlkid on 9/15/2012

Nice one with good explanation