<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<Connection Name="OLEDB" ConnectionString="Data Source=localhost;Initial Catalog=AdventureWorks2008R2;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;" />
	</Connections>
	<Packages>
		<Package Name="COZYROC_LookupPlus" Language="None" ConstraintMode="Parallel" ProtectionLevel="EncryptSensitiveWithUserKey" >
			<Variables>
				<Variable Name="LookupSql" DataType="String" IncludeInDebugDump="Exclude">SELECT [e].[BusinessEntityID],[e].[NationalIDNumber] FROM [HumanResources].[Employee] e</Variable>
			</Variables>
			<Tasks>
				<Dataflow Name="Data Flow Task" >
					<Transformations>
						<OleDbSource Name="OLE DB Source" DefaultCodePage="1252" ConnectionName="OLEDB">
							<Annotations>
								<Annotation AnnotationType="Description">OLE DB Source</Annotation>
							</Annotations>
							<ExternalTableInput Table="[Person].[Person]" />
						</OleDbSource>
						<CustomComponent Name="Lookup Plus Direct Input" ComponentTypeName="CozyRoc.SqlServer.SSIS.LookupPlus, CozyRoc.SSISPlus.2008, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea" ContactInfo="Lookup multiple values in a reference dataset by using exact matching.;CozyRoc LLC; SSIS+; © 2006-2009 CozyRoc LLC; All Rights Reserved; http://www.cozyroc.com/;0">
							<Annotations>
								<Annotation AnnotationType="Description">Lookup multiple values in a reference dataset by using exact matching.</Annotation>
							</Annotations>
							<CustomProperties>
								<CustomProperty Name="LookupMetadataXml" DataType="String"  SupportsExpression="true" >&lt;lookups&gt;&lt;lookup inputColumn="BusinessEntityID" onNull="0" noMatch="-1"&gt;&lt;result name="JobTitle" /&gt;&lt;reference connectionType="OLEDB" runtimeConnectionName="Connection1" sourceType="Query" source="SELECT  [e].[BusinessEntityID]&amp;#xD;&amp;#xA;       ,[e].[NationalIDNumber]&amp;#xD;&amp;#xA;       ,[e].[LoginID]&amp;#xD;&amp;#xA;       ,[e].[JobTitle]&amp;#xD;&amp;#xA;FROM [HumanResources].[Employee] e" keyColumn="BusinessEntityID" valueColumn="JobTitle" /&gt;&lt;/lookup&gt;&lt;/lookups&gt;</CustomProperty>
							</CustomProperties>
							<InputPaths>
								<InputPath OutputPathName="OLE DB Source.Output" Identifier="Input">
									<InputColumns>
										<InputColumn SourceColumn="BusinessEntityID" />
									</InputColumns>
								</InputPath>
							</InputPaths>
							<OutputPaths>
								<OutputPath Name="Output" SynchronousInput="Input">
									<OutputColumns>
										<OutputColumn Name="JobTitle" Length="50" DataType="String" />
									</OutputColumns>
								</OutputPath>
							</OutputPaths>
							<Connections>
								<Connection Name="Connection1" ConnectionName="OLEDB" />
							</Connections>
						</CustomComponent>
						<CustomComponent Name="Lookup Plus from Variable" ComponentTypeName="CozyRoc.SqlServer.SSIS.LookupPlus, CozyRoc.SSISPlus.2008, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea" ContactInfo="Lookup multiple values in a reference dataset by using exact matching.;COZYROC LLC; SSIS+; © 2006-2012 COZYROC LLC; All Rights Reserved; http://www.cozyroc.com/;0">
							<Annotations>
								<Annotation AnnotationType="Description">Lookup multiple values in a reference dataset by using exact matching.</Annotation>
							</Annotations>
							<CustomProperties>
								<CustomProperty Name="LookupMetadataXml" DataType="String" TypeConverter="NOTBROWSABLE" >&lt;lookups&gt;&lt;lookup inputColumn="BusinessEntityID" onNull="0" noMatch="-1"&gt;&lt;result name="NationalIDNumber" /&gt;&lt;reference connectionType="OLEDB" runtimeConnectionName="Connection1" sourceType="FromVariable" source="LookupSql" keyColumn="" valueColumn="" /&gt;&lt;/lookup&gt;&lt;/lookups&gt;</CustomProperty>
							</CustomProperties>
							<InputPaths>
								<InputPath OutputPathName="Lookup Plus Direct Input.Output" SsisName="Input" Identifier="Input">
									<InputColumns>
										<InputColumn SourceColumn="BusinessEntityID" />
									</InputColumns>
								</InputPath>
							</InputPaths>
							<OutputPaths>
								<OutputPath Name="Output" SynchronousInput="Input">
									<OutputColumns>
										<OutputColumn Name="NationalIDNumber" Length="15" DataType="String" />
									</OutputColumns>
								</OutputPath>
							</OutputPaths>
							<Connections>
								<Connection Name="Connection1" ConnectionName="OLEDB" />
							</Connections>
						</CustomComponent>
						<CustomComponent Name="Trash Destination" ComponentTypeName="Konesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992b" ContactInfo="Trash Destination; http://www.konesans.com">
							<Annotations>
								<Annotation AnnotationType="Description">Terminate the data flow path</Annotation>
							</Annotations>
							<InputPaths>
								<InputPath OutputPathName="Lookup Plus from Variable.Output" SsisName="TrashInput" Identifier="TrashInput" />
							</InputPaths>
						</CustomComponent>
					</Transformations>
				</Dataflow>
			</Tasks>
			<Connections>
				<Connection ConnectionName="OLEDB" />
			</Connections>
		</Package>
	</Packages>
</Biml>