October 26, 2016 at 2:11 am
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
October 26, 2016 at 5:43 am
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.
October 28, 2016 at 11:16 am
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
October 28, 2016 at 11:22 am
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.
October 28, 2016 at 11:42 am
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.
October 28, 2016 at 11:48 am
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.
October 28, 2016 at 1:55 pm
Thankyou
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply