<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.
Comments
corey7
4:53am 08.25.19
Not perfect, but much closer!