Skip to content

Instantly share code, notes, and snippets.

@billinkc
Last active December 18, 2015 14:49
Show Gist options
  • Save billinkc/5799825 to your computer and use it in GitHub Desktop.
Save billinkc/5799825 to your computer and use it in GitHub Desktop.
A biml script that should create a project level parameter named FolderBase, a package named POC which has a package level parameter, subfolder and a Variable that puts it all together.
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<PackageProjects>
<PackageProject Name="ProjectParameterTest" ProtectionLevel="DontSaveSensitive">
<Parameters>
<!-- I think this is the project parameter-->
<Parameter DataType="String" Name="FolderBase">C:\ssisdata</Parameter>
</Parameters>
<Packages>
<Package IsEntryPoint="true" PackageName="POC"/>
</Packages>
</PackageProject>
</PackageProjects>
<Packages>
<Package Name="POC" ConstraintMode="Linear">
<!-- Package parameter-->
<Parameters>
<Parameter DataType="String" Name="Subfolder">POC</Parameter>
</Parameters>
<Variables>
<Variable Name="FolderInput" DataType="String" EvaluateAsExpression="true">@[$Project::FolderBase] + "\\" + @[$Package::Subfolder]</Variable>
</Variables>
</Package>
</Packages>
</Biml>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment