Just check the Transformation Transpose object using SSIS BIML

How to uncheck a Transformation Transformation (FLT) object in SQL Server 2008 using BID and BIML. I suppose that adds the output column to the output path, I don’t know? I would like my conclusion to be

Search Column =
Lookup Attribute column = AddThisColumn

Output Alias ​​= Attribute2
Output Alias ​​= AddThisColumn

Below is a BIML script along with 2x screenshots, 1) the AddThisColumn unticked flag (current status) 2) the AddThisColumn flag is checked (what would I like)

            <Biml xmlns="http://schemas.varigence.com/biml.xsd">
                <Connections>
                 <OleDbConnection Name="SportsData" ConnectionString="Provider=SQLNCLI10;Server=myServer;Initial Catalog=myCatalog;Integrated Security=SSPI;" DelayValidation="true" />
                </Connections>
                <Packages>
                    <Package Name="_my Package" ConstraintMode="Linear">
                        <Tasks>    
                            <Dataflow Name="My Dataflow Task">
                                <Transformations>
                                    <OleDbSource Name="SurveyResponses" ConnectionName="SportsData">
                                        <DirectInput>select * from SurveyResponses</DirectInput>
                                    </OleDbSource>
                                    <!-- Performs a fuzzy lookup on the Attribute column against the JuniorSurveyResponse DB, and outputs the corresponding Response column to NewResponse. -->
                                    <FuzzyLookup Name="Fuzzy Lookup Transformation" ConnectionName="SportsData" Exhaustive="true" 
                                                 MatchIndexName="dbo.JuniorSurveyResponsesIndex" DropExistingIndex="false" 
                                                 CopyReferenceTable="true" WarmCaches="false" MatchIndexOptions="ReuseExistingIndex" ValidateExternalMetadata="false" > 
                                        <ExternalReferenceTableInput Table="dbo.JuniorSurveyResponses" />
                                        <Inputs> 
                                            <Column SourceColumn="Attribute" TargetColumn="Attribute"   />
                                        </Inputs>
                                        <Outputs> 
                                            <Column SourceColumn="Attribute" TargetColumn="Attribute2"  />

                                        </Outputs>
                                        <InputPath OutputPathName="SurveyResponses.Output" />
                                    </FuzzyLookup>

                                </Transformations>
                            </Dataflow>
                        </Tasks>
                    </Package>
                </Packages>
                </Biml>

        <#@ template language="C#" hostspecific="true"#>
        <#@ import namespace="System.Data" #>
        <#@ import namespace="Varigence.Hadron.CoreLowerer.SchemaManagement" #>

        <!--

        CREATE TABLE dbo.JuniorSurveyResponses
        (
            Attribute varchar(50)
        ,   Response varchar(50)
        ,   AddThisColum varchar(50)
        );

        CREATE TABLE dbo.SurveyResponses
        (
            Attribute varchar(50)
        ,   Response varchar(50)
        );

        -->

Below should be an output image where a column named AddThisColumn is not set. addThisColumn is unchecked

Below should be an output image, where a column named AddThisColumn is a check. How to do this script? addThisColumn is checked

+3
1

, ? , Column Outputs .

<Outputs>
    <Column SourceColumn="Attribute" TargetColumn="Attribute2"  />
    <Column SourceColumn="AddThisColum" TargetColumn="AddThisColumn" />
</Outputs>

, , , , Attribute2, .

Moar columns

+5

All Articles