Package Parameters

gravatar

Paul S. Waters

This is a simple snippet that shows how to declare and reference package parameters in Biml for use with SSIS 2012.

published 05.01.13

last updated 05.01.13


Share

Tags

  • Parameters
                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Packages>
		<Package Name="PackageParameters" ConstraintMode="Parallel">
			<Parameters>
				<Parameter Name="PackageParamStr" DataType="String">Test</Parameter>
			</Parameters>
			<Variables>
				<Variable Name="TestPackageParam" DataType="String" EvaluateAsExpression="true">@[$Package::PackageParamStr]</Variable>
			</Variables>
		</Package>
	</Packages>
</Biml>
                        

This is a simple snippet that shows how to declare and reference package parameters in Biml for use with SSIS 2012.

You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

gravatar

Geoff

1:56am 06.30.13

Thanks for the example. I found that you can use the parameter directly as a variable by just using the name of the parameter (i.e. PackageParamStr) no prefix. However I am struggling to pass a variable to a parameter from ExecutePackage task within the new Project Package in 2012. Do you have a snippet for passing the parameter?