Skip to content

Instantly share code, notes, and snippets.

@billinkc
Created May 6, 2014 17:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save billinkc/63517c46029f518a99c1 to your computer and use it in GitHub Desktop.
Save billinkc/63517c46029f518a99c1 to your computer and use it in GitHub Desktop.
Foreach loop container that runs packages
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Connections>
<FileConnection Name="RunLong.dtsx" FilePath="C:\sandbox\VarigenceForums\VarigenceForums\RunLong.dtsx" />
</Connections>
<Packages>
<Package Name="ZanePOC" ForcedExecutionValueDataType="Empty" Language="None" ConstraintMode="Parallel" SsisPackageType="5" VersionBuild="6" CreationDate="2014-05-06T12:20:02">
<Variables>
<Variable Name="FullTarget" DataType="String" IncludeInDebugDump="Exclude">C:\sandbox\VarigenceForums\VarigenceForums\RunLong.dtsx</Variable>
</Variables>
<Tasks>
<ForEachFileLoop Name="FELC All the dtsx" ForcedExecutionValueDataType="Empty" ConstraintMode="Parallel" Folder="C:\sandbox\VarigenceForums\VarigenceForums" FileSpecification="*.dtsx">
<Tasks>
<ExecutePackage Name="EPT FullMonty" ForcedExecutionValueDataType="Empty">
<File ConnectionName="RunLong.dtsx" />
</ExecutePackage>
</Tasks>
<VariableMappings>
<VariableMapping Name="0" VariableName="User.FullTarget" />
</VariableMappings>
</ForEachFileLoop>
</Tasks>
<Connections>
<Connection ConnectionName="RunLong.dtsx">
<Expressions>
<Expression PropertyName="RunLong.dtsx.ConnectionString">@[User::FullTarget]</Expression>
</Expressions>
</Connection>
</Connections>
</Package>
</Packages>
</Biml>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment