Loop databases

Loop databases.biml

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <OleDbConnection Name="CM_OLE" ConnectionString="Data Source=localhost\dev2012;Initial Catalog=tempdb;Provider=SQLNCLI11.0;Integrated Security=SSPI;"/>
    </Connections>
    <Packages>
        <Package ConstraintMode="Linear" Name="LoopDeDatabases">
            <Variables>
                <Variable DataType="String" Name="CurrentDatabase">tempdb</Variable>
                <Variable DataType="String" Name="QuerySource">SELECT D.name FROM sys.databases AS D;</Variable>
                <Variable DataType="Object" Name="rsResults"></Variable>
            </Variables>
            <Connections>
                <Connection ConnectionName="CM_OLE">
                    <Expressions>
                        <Expression ExternalProperty="InitialCatalog">@[User::CurrentDatabase]</Expression>
                    </Expressions>
                </Connection>
            </Connections>
            <Tasks>
                <ExecuteSQL 
                    ConnectionName="CM_OLE" 
                    Name="SQL Acquire Data"
                    ResultSet="Full">
                    <VariableInput VariableName="User.QuerySource"></VariableInput>
                    <Results>
                        <Result VariableName="User.rsResults" Name="0"></Result>
                    </Results>
                </ExecuteSQL>
                <ForEachAdoLoop 
                    SourceVariableName="User.rsResults" 
                    ConstraintMode="Linear" 
                    Name="FELC Enumerate Databases">
                    <VariableMappings>
                        <VariableMapping VariableName="User.CurrentDatabase" Name="0"></VariableMapping>
                    </VariableMappings>
                    <Tasks>
                        <ExecuteSQL ConnectionName="CM_OLE" Name="SQL Do something">
                            <DirectInput>SELECT DB_NAME();</DirectInput>
                        </ExecuteSQL>
                    </Tasks>
                </ForEachAdoLoop>
            </Tasks>
        </Package>
    </Packages>
</Biml>