Last active
December 18, 2015 14:49
-
-
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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