This project has moved. For the latest updates, please go here. biml SQL 2012 Execute Package Task Project Reference

Jun 7, 2013 at 9:06 AM

Is it possible to generate an Execute Package Task with ReferenceType set to Project Reference?


Jun 7, 2013 at 9:22 AM
Jun 7, 2013 at 9:23 AM
Yes, here is some sample code:
<Biml xmlns="">
    <Package Name="Package1" ConstraintMode="Parallel" ProtectionLevel="EncryptSensitiveWithUserKey">
    <Package Name="Package2" ConstraintMode="Parallel" ProtectionLevel="EncryptSensitiveWithUserKey">
        <ExecutePackage Name="ExecPackage1">
          <ExternalProjectPackage Package="Package1.dtsx" />
Jun 7, 2013 at 9:27 AM
Thanks Scott!

Still one question: what is the syntax for Parameter bindings?


Jun 7, 2013 at 9:30 AM
What kind of parameters? Parent package? Package? Project? ExecuteSQL? Something else?

Jun 7, 2013 at 9:33 AM
I want to pass a variable from the master packages Execute Package Task to the child package, using a project reference (cfr. Parameter bindings screen in the Execute Package Task Editor)

Sep 13, 2013 at 5:31 AM
  • 1
How to pass pass a variable from the master package to the child package in the "Execute Package Task"?
Mar 18, 2015 at 3:05 AM
This is a really old thread and I'm sure you've either figured this out by now or don't care, but here's an example of passing a variable to a child package parameter:
Marked as answer by furmangg on 3/17/2015 at 8:05 PM