Trash Destination Component by Konesans

gravatar

Paul S. Waters

Biml for how to use the Trash Destination Component by Konesans.

published 10.21.12

last updated 10.23.12


Share

Tags

  • Custom Component
  • Konesans
                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<Connection Name="AW" ConnectionString="Data Source=localhost;Initial Catalog=AdventureWorks2008R2;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;" />
	</Connections>
	<Packages>
		<Package Name="Konesans_TrashDestination" Language="None" ConstraintMode="Parallel" ProtectionLevel="EncryptSensitiveWithUserKey" >
			<Tasks>
				<Dataflow Name="Data Flow Task" >
					<Transformations>
						<OleDbSource Name="OLE DB Source" ConnectionName="AW">
                			<ExternalTableInput Table="[Person].[Person]" />
						</OleDbSource>
						<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="OLE DB Source.Output" SsisName="TrashInput" Identifier="TrashInput" />
							</InputPaths>
						</CustomComponent>
					</Transformations>
				</Dataflow>
			</Tasks>
		</Package>
	</Packages>
</Biml>
                        

The Trash Destination Component by Konesans can be downloaded from http://www.sqlis.com/sqlis/post/Trash-Destination-Adapter.aspx.

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

Comments

There are no comments yet.