tag:blogger.com,1999:blog-2303058199815958946.post7539043939924652967..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: Passing variables from a Parent Package To a Child - part IIJoost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2303058199815958946.post-869066935876149262013-02-21T22:10:02.761+01:002013-02-21T22:10:02.761+01:00Parent package variable configuration only work if...Parent package variable configuration only work if you call the child package from the parent package. And beware of the order of events in a package when you're using Parent Package Variable Configuration. Order is different to other configurations: <a href="http://weblogs.sqlteam.com/dmauri/archive/2006/04/02/9489.aspx" rel="nofollow">More info</a>.<br /><br><br><br />Also see the SSIS MSDN forum for general SSIS questions. You will get a lot more/faster/better answers.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-85550375349766934492013-02-21T16:36:53.811+01:002013-02-21T16:36:53.811+01:00I used two jobs(J1 and J2) with SQL server configu...I used two jobs(J1 and J2) with SQL server configuration types. Both jobs runs independently. But J2 is the subset of J1 (in terms of operations). So i made J2 as Child and J1 as parent. When i try J2 has multiple configurations types(SQL Server and Parent Configs both), it just don't work. J2 refers to SQL server config type only. It's not overriden by Parent Configs after setting up Paretn config type on the top though. J2 has to run independently too and when J1 runs J2 should run with parent configurations. <br /><br />In short, the question is how to override one configuration type with other. Sorting of config types in package configurations organizer don't work. Is this is a bug in SSIS 2008 ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-4115424901189081962011-07-06T08:17:30.934+02:002011-07-06T08:17:30.934+02:00@dczepyrus: I haven't detect differences, besi...@dczepyrus: I haven't detect differences, besides the one you mentioned. The result of both methods is the same. You can test it yourself with the solution you can <a href="https://sites.google.com/site/ssisblogspot/ParentChildVariables.zip?attredirects=0" rel="nofollow">download</a>.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-23816173223058660352011-07-06T05:47:17.979+02:002011-07-06T05:47:17.979+02:00Is there any difference between the two methods?
W...Is there any difference between the two methods?<br />What is the limitation for both of them beside the child can't run on its own?dczepyrushttps://www.blogger.com/profile/09767664254356734701noreply@blogger.com