Thursday, September 13, 2012

BIML Setting up Package Configuration

Example file for creating a package using the [dbo].[SSIS Configurations] Table:

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <AdoNetConnection
            Name ="CnAdoAdventureWorks2012"
            Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
            ConnectionString ="Data Source=.\MSSQL2012;Integrated Security=SSPI;Connect Timeout=30;"
            RetainSameConnection="true">
        </AdoNetConnection>
        <OleDbConnection
            Name="CnOleDBAdventureWorks2012"
            ConnectionString="Data Source=.\MSSQL2012;Integrated Security=SSPI;Connect Timeout=30;"
            RetainSameConnection="true">
        </OleDbConnection>
    </Connections>

    <Packages>
        <Package Name ="Config.SSISConfigurations.Table" ConstraintMode="Linear">
            <Annotations>
                <Annotation>
                    File: Config.SSISConfigurations.Table.biml
                    Demo biml for setting up the Package config
                    using the [dbo].[SSIS Configurations] Table
                    Enviroment:
                    DB: MS-SQL2012
                    BIML: 1.6 VS2010 BIDS Helper
                    (c) John Minkjan biml101.blogspot.com
                </Annotation>
            </Annotations>
            <PackageConfigurations>
                <PackageConfiguration
                    Name="cfg_ConfigName"
                    ConnectionName="CnOleDBAdventureWorks2012">
                    <ExternalTableInput
                        Table="[dbo].[SSIS Configurations]">                       
                    </ExternalTableInput >
                </PackageConfiguration>
            </PackageConfigurations>           
        </Package>
    </Packages>
</Biml>

Till Next Time

1 comment:

  1. Do you have an example of using Parent Package Configuration?

    ReplyDelete