pass variable values from parent to child package - ssis 2012

Question

pass variable values from parent to child package - ssis 2012

arkiboys

Hall of Fame

Points: 3958
More actions
October 26, 2016 at 2:11 am

#331234

Hello,
I am using sql server 2012 - VS 2015.
parent package has variables v1 and v2, where v1 is the name of a stored proc and v2 is ID value
They need to be picked up in child package.
inside child package there are two variables as vc1 and vc2
inside child package there is execute task which has the sql statement as EXEC ? ?
Question:
How can I pass the variable values from parent to child package for this please?
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99126 More actions · Answer 1

Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Phil Parkin SSC Guru Points: 246686 More actions · Answer 2

Thom A (10/26/2016)
Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.

+1, this is the way to do it.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

arkiboys Hall of Fame Points: 3958 More actions · Answer 3

Thom A (10/26/2016)
Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.

Hello,

What topic does this come under so that I can search for that topic to read about it?

Alternatively can you refer me to a link for this topic please?

Thanks

Phil Parkin SSC Guru Points: 246686 More actions · Answer 4

arkiboys (10/28/2016)
Thom A (10/26/2016)
Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.
Hello,
What topic does this come under so that I can search for that topic to read about it?
Alternatively can you refer me to a link for this topic please?
Thanks

Have a look here.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

arkiboys Hall of Fame Points: 3958 More actions · Answer 5

Phil Parkin (10/28/2016)
arkiboys (10/28/2016)
Thom A (10/26/2016)
Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.
Hello,
What topic does this come under so that I can search for that topic to read about it?
Alternatively can you refer me to a link for this topic please?
Thanks
Have a look here.

Hi, ,did not find an example there.

Phil Parkin SSC Guru Points: 246686 More actions · Answer 6

arkiboys (10/28/2016)
Phil Parkin (10/28/2016)
arkiboys (10/28/2016)
Thom A (10/26/2016)
Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.
Hello,
What topic does this come under so that I can search for that topic to read about it?
Alternatively can you refer me to a link for this topic please?
Thanks
Have a look here.
Hi, ,did not find an example there.

You did not ask for an example. You asked for a topic where you could 'read about it'. The section titled 'Passing Values to Child Packages' was, I thought, a pretty good place to start reading about it.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

arkiboys Hall of Fame Points: 3958 More actions · Answer 7

arkiboys

Hall of Fame

Points: 3958

October 28, 2016 at 1:55 pm

#1909433

Thankyou