Assign Properties To Execute Package Task Ssis Object Using Biml

using biml (via BIDS helper in visual studio) how do i assign values to the properties of the SSIS 2008 Execute Package Task object, specifically Location: SQL Server Connection:

Solution 1:

Inside your ExecutePackage tag, you'll need to specify that it's a SqlServer source.

In the following declaration, I create two connection managers, one for a file based connection manager and one for a SQL connection to my named instance.

The Biml itself creates 2 packages. A Child and Parent. The Parent package creates two Execute Package Tasks

<Bimlxmlns="http://schemas.varigence.com/biml.xsd"><Connections><FileConnectionName="FCChild"FilePath="c:\Users\bfellows\documents\visual studio 2012\Projects\SSISPOC\PackageDeploymentModel\Child.dtsx"></FileConnection><OleDbConnectionName="OLEChild"ConnectionString="Data Source=localhost\dev2012;Initial Catalog=tempdb;Provider=SQLNCLI10.1;Integrated Security=SSPI;"></OleDbConnection></Connections><Packages><PackageName="Child"ConstraintMode="Linear"
             ></Package><PackageName="Parent"ConstraintMode="Linear"><Tasks><ExecutePackageName="EPT File Child"><FileConnectionName="FCChild"></File></ExecutePackage><ExecutePackageName="EPT SS Child"><SqlServerConnectionName="OLEChild"PackagePath="\Child"></SqlServer></ExecutePackage></Tasks></Package></Packages></Biml>

The resulting Execute Package Task for the SQL Server appears as