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

gravatar

corey7

4:53am 08.25.19
  • BimlExpress2019's "Convert SSIS Packages to BIML" doesn't pick out the full ComponentTypeName attribute value for the Konesans Trash - Destination into the generated BIML file. You'll need to get that from the component in the SSIS package. It also doesn't add the ... either. You'll need to manually add that in, like in the example.
  • For pasting the BIML from BimlExpress to say BIDS 2008, change the ConstraintModes to "Linear" or "Parallel".
  • Also, for the Konesans Trash Destination, you can change the component version: 2.0.0.0 SSIS 2008 3.0.0.0 SSIS 2012 4.0.0.0 SSIS 2014 5.0.0.0 SSIS 2016 6.0.0.0 SSIS 2017 (I don't know if Konesans has built their components for SSIS 2019? they're not on www.SQLIS.com...)

Not perfect, but much closer!