parent package variable

Question

hi

  i create a parent package variable in ssis project..variable name called dbconn.so in that dbconn i passes connection string as variable to all child packages..but i doesnt pass that parent package variable to child package..child package use own variable connection string..

how to pass variable to child packages

Answer 1

via script task: http://microsoft-ssis.blogspot.com/2010/12/passing-variables-from-parent-package.html or via configurations http://microsoft-ssis.blogspot.com/2011/06/passing-variables-from-parent-package.html

In this case you could also create one config (file) for that connection and add that config to all packages that use that same connection.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

In which package did you create the parent package variable?
How did you configure your connection managers?

---

MCTS, MCITP - Please mark posts as answered where appropriate.
Answer #1: Have you tried turning it off and on again?
Answer #2: It depends...

Answer 3

i create a package called master package in that master package i create a dbconn variable..in that master package i used excute package task thats exec more than 15 packages..so i master package and child package i used package config- parent package variable as dbconn

Answer 4

So you created a parent package variable in the child packages that takes the dbconn variable of the parent, right?
And you put an expression on the connection managers in the child packages that dynamically reconfigures the connectionstring, right?

---

MCTS, MCITP - Please mark posts as answered where appropriate.
Answer #1: Have you tried turning it off and on again?
Answer #2: It depends...

Answer 5

Mm s ur right

Answer 6

Hi sql.anandan,

Here is a similar thread, please refer to Todd's reply:
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8888c324-8163-43f3-9acd-d71c4ebd96ff 

For more information about the topic, please see:
How to: Use the Values of Parent Variables in a Child Package: http://msdn.microsoft.com/en-us/library/ms345179.aspx

Thanks,
Eileen

Answer 7

what did you call the variable in the child package? It should be different to the variable in the parent package

I normally use a structure of pVariableName for parent package variables and cVariableName for child package variables that inherit from a parent

---

Rgds Geoff
----------------------------------------------------------
Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.