Flow Synchronization Component by COZYROC

gravatar

COZYROC

Biml for how to use the Flow Synchronization Component by COZYROC.

published 10.23.12

last updated 10.23.12


Share

Tags

  • COZYROC
  • Custom Component
                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <Connection Name="AW" ConnectionString="Data Source=.;Initial Catalog=AdventureWorks2008R2;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-Package-{5D18909A-2283-4AE2-96CE-3807DF7EAA48}LocalHost.Conformer_DEV;" />
    </Connections>
    <Packages>
        <Package Name="COZYROC_FlowSync" ConstraintMode="Parallel" >
            <Tasks>
                <Dataflow Name="Data Flow Task 1">
                    <Transformations>
                        <OleDbSource Name="OLE DB Source" DefaultCodePage="1252" ConnectionName="AW">
                            <ExternalTableInput Table="[Person].[Person]" />
                        </OleDbSource>
                        <CustomComponent Name="Flow Synchronization" ComponentTypeName="CozyRoc.SqlServer.SSIS.FlowSync, CozyRoc.SSISPlus.2008, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea" ContactInfo="">
                            <Annotations>
                                <Annotation AnnotationType="Description">Make two or more data flows run at same speed.</Annotation>
                            </Annotations>
                            <CustomProperties>
                                <CustomProperty Name="MaxDelta" DataType="Int32" TypeConverter="" UITypeEditor="" >550</CustomProperty>
                                <CustomProperty Name="IsSemaphoreVariable" DataType="Boolean" TypeConverter="" UITypeEditor="" >false</CustomProperty>
                                <CustomProperty Name="Semaphore" DataType="String" TypeConverter="" UITypeEditor="" >FLOW SYNCHRONIZATION</CustomProperty>
                            </CustomProperties>
                            <InputPaths>
                                <InputPath OutputPathName="OLE DB Source.Output" SsisName="Input" ErrorOrTruncationOperation="" Identifier="Input" />
                            </InputPaths>
                            <OutputPaths>
                                <OutputPath Name="Output" ErrorOrTruncationOperation="" SynchronousInput="Input" />
                            </OutputPaths>
                        </CustomComponent>
                        <Multicast Name="Multicast">
                            <Annotations>
                                <Annotation AnnotationType="Description">Creates copies of a dataset.</Annotation>
                            </Annotations>
                            <InputPath OutputPathName="Flow Synchronization.Output" SsisName="Multicast Input 1" />
                        </Multicast>
                    </Transformations>
                </Dataflow>
                <Dataflow Name="Data Flow Task 2">
                    <Transformations>
                        <OleDbSource Name="OLE DB Source" DefaultCodePage="1252" ConnectionName="AW">
                            <ExternalTableInput Table="[Sales].[SalesPerson]" />
                        </OleDbSource>
                        <CustomComponent Name="Flow Synchronization" ComponentTypeName="CozyRoc.SqlServer.SSIS.FlowSync, CozyRoc.SSISPlus.2008, Version=1.0.0.0, Culture=neutral, PublicKeyToken=16cf490bb80c34ea" ContactInfo="">
                            <Annotations>
                                <Annotation AnnotationType="Description">Make two or more data flows run at same speed.</Annotation>
                            </Annotations>
                            <CustomProperties>
                                <CustomProperty Name="MaxDelta" DataType="Int32" TypeConverter="" UITypeEditor="">550</CustomProperty>
                                <CustomProperty Name="IsSemaphoreVariable" DataType="Boolean" TypeConverter="" UITypeEditor="" >false</CustomProperty>
                                <CustomProperty Name="Semaphore" DataType="String" TypeConverter="" UITypeEditor="">FLOW SYNCHRONIZATION</CustomProperty>
                            </CustomProperties>
                            <InputPaths>
                                <InputPath OutputPathName="OLE DB Source.Output" SsisName="Input" ErrorOrTruncationOperation="" Identifier="Input" />
                            </InputPaths>
                            <OutputPaths>
                                <OutputPath Name="Output" ErrorOrTruncationOperation="" SynchronousInput="Input" />
                            </OutputPaths>
                        </CustomComponent>
                        <Multicast Name="Multicast">
                            <InputPath OutputPathName="Flow Synchronization.Output" SsisName="Multicast Input 1" />
                        </Multicast>
                    </Transformations>
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>
                        

For more information on the Flow Synchronization Component by COZYROC see the documentation at http://cozyroc.com/ssis/flow-synchronization.

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.