Databases
StackOverflow2013
Postsdbo
POPass package parameters to Execute Package Task
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPass package parameters to Execute Package Task
    primarykey
    data
    text
    <p>I'm using BIML to generate a coordination package that will execute multiple SSIS packages (some parallel and some linear). <em>(I'm using VS2012 and the SSIS project deployment model)</em></p> <p>With the code below I can generate two dummy <a href="https://www.varigence.com/Documentation/Samples/Biml/Execute+Package" rel="nofollow">Execute Package Tasks</a>:</p> <pre><code>&lt;Biml xmlns="http://schemas.varigence.com/biml.xsd"&gt; &lt;Packages&gt; &lt;Package ConstraintMode="Linear" AutoCreateConfigurationsType="None" ProtectionLevel="DontSaveSensitive" Name="Coordination"&gt; &lt;Parameters&gt; &lt;Parameter Name="param1" DataType="Int64" IsRequired="true" IsSensitive="false"&gt;1&lt;/Parameter&gt; &lt;/Parameters&gt; &lt;Tasks&gt; &lt;Container Name="SEQ container" ConstraintMode="Parallel"&gt; &lt;Tasks&gt; &lt;ExecutePackage Name="Run Package1"&gt; &lt;ExternalProjectPackage Package="Package1.dtsx" /&gt; &lt;/ExecutePackage&gt; &lt;ExecutePackage Name="Run Package2"&gt; &lt;ExternalProjectPackage Package="Package2.dtsx" /&gt; &lt;/ExecutePackage&gt; &lt;/Tasks&gt; &lt;/Container&gt; &lt;/Tasks&gt; &lt;/Package&gt; &lt;/Packages&gt; &lt;/Biml&gt; </code></pre> <p>BIDS Helper with generate the coordination package without any errors. </p> <p>The next step in completing the coordination package is using a package parameter to control the executed packages. I don't see any way to pass the parameter "param1". </p> <p>Is there any way to pass the parameter in BIML? <em>(in the <a href="https://www.varigence.com/Documentation/Samples/Biml/Execute+SQL+Parameters" rel="nofollow">Execute SQL task</a> I see this option, but not here)</em> </p> <p>UPDATE: There is a new version of BIDSHelper with the right support for project parameters...-> <a href="http://bidshelper.codeplex.com/releases/view/112755" rel="nofollow">http://bidshelper.codeplex.com/releases/view/112755</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRuud van de Beeten
    1. USRuud van de Beeten
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPass package parameters to Execute Package Task
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPass package parameters to Execute Package Task
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have not seen a mechanism and I asked a similar question on the varigence [forums](http://varigence.com/Forums?threadID=191)
      singulars
      1. POPass package parameters to Execute Package Task
      1. USbillinkc
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload