Home Forums Data Warehousing Integration Services running SSIS packages in msdb with SQL Agent on SQL Server 2008 R2 RE: running SSIS packages in msdb with SQL Agent on SQL Server 2008 R2

  • 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>