Thanks, it worked.
I have a configuration file where I configure both the child as package on the file system and on the db.
I can switch between the two by changing the connection between the .dtsx and the DB, like in the
example below. Child1 in in the DB and Child2 on the filesystem, if I change Child2 connection to DWH.TestDB
the master executes the Child2 package in the DB. Thanks for your input.
<DTSConfiguration>
<DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="ADMINETATFR\da-bianchim" GeneratedFromPackageName="A - MDSI Master Loader" GeneratedFromPackageID="{100CFBFC-117A-4D44-9C64-F0E616721773}" GeneratedDate="20.03.2013 14:44:17" />
</DTSConfigurationHeading>
<Configuration ConfiguredType="Property" Path="\Package\Child1.Properties[Connection]" ValueType="String">
<ConfiguredValue>DWH.TestDB</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package\Child1.Properties[PackageName]" ValueType="String">
<ConfiguredValue>\Test\Child1</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Child2.Properties[Connection]" ValueType="String">
<ConfiguredValue>G:\SSIS\Projects\Test\Child2.dtsx</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package\Child2.Properties[PackageName]" ValueType="String">
<ConfiguredValue>\Test\Child2</ConfiguredValue>
</Configuration>
</DTSConfiguration>