July 3, 2012 at 1:37 am
Just curious about the use of Parent Package Configuration.
If the only purpose of this is to pass the parent package variables to the child package, can't we achieve this using environment variables ?
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 3, 2012 at 1:40 am
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 3, 2012 at 1:54 am
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?
Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 3, 2012 at 1:57 am
rhythmk (7/3/2012)
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.
Of course you can't.
But a lot of people post questions about newer versions of SSIS in this forum, so it's always useful to mention the version you're working with.
Regarding the question:
a windows environment variable is fixed. A variable in a parent package can still be altered by the package logic before the child package is executed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 3, 2012 at 2:05 am
But a lot of people post questions about newer versions of SSIS in this forum, so it's always useful to mention the version you're working with.
Maybe we should push for another SSIS forum, given that 2012 brings so many new features, I can imagine there being more and more confusion...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 3, 2012 at 2:10 am
There is already a "general" Integration Services forum in the Data Warehouse section, but it is so far at the bottom no one notices it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 3, 2012 at 2:25 am
Koen Verbeeck (7/3/2012)
There is already a "general" Integration Services forum in the Data Warehouse section, but it is so far at the bottom no one notices it.
🙂 QED.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 3, 2012 at 3:44 am
Koen Verbeeck (7/3/2012)
rhythmk (7/3/2012)
Koen Verbeeck (7/3/2012)
Are we talking about SSIS 2012 environment variables or Windows environment variables?Hey Koen,
Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.
Of course you can't.
But a lot of people post questions about newer versions of SSIS in this forum, so it's always useful to mention the version you're working with.
Regarding the question:
a windows environment variable is fixed. A variable in a parent package can still be altered by the package logic before the child package is executed.
Thanks Koen.
To avoid any confusion I chose this forum SQL Server 2005 Integration Services 🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 4, 2012 at 3:20 am
Parent package variables work well for me with a config file driving the parent package and that setting and passing variables to its children - the config file holds the root directories to use e.g. for imports and the parent uses that with other variables to create the appropriate dated, company specific subdirectory in another variable for each call of the child packages - a child package is called once for each company for example.
July 6, 2012 at 10:02 am
I use parent pkg configs for several things - server, database, local file path, toggle in-pkg validation on/off...
It also passes in a parent pkg key to children so our auditing is easy to query by parent pkg with child pkg results.
This config method is very easy to maintain. I would expect that you could use environment variables but those don't cover all the info I need.
July 9, 2012 at 12:13 am
herladygeekedness (7/6/2012)
I use parent pkg configs for several things - server, database, local file path, toggle in-pkg validation on/off...It also passes in a parent pkg key to children so our auditing is easy to query by parent pkg with child pkg results.
This config method is very easy to maintain. I would expect that you could use environment variables but those don't cover all the info I need.
But all these details can be handled by Environment variable, right ? However I do agree with Koen's comment that the value in environment variables are fixed while in case of Parent package the variable value can be modified in parent package before executing the child package.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 10, 2012 at 3:30 pm
hey all -
something I ran into just recently when working on a package that uses an environment variable to config from (maybe everyone else knows this already). The environment variable seems to be tied to the physical machine. They are not settable for individual virtual machines
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply