Vista Aggregate SQL Provider

Microsoft.Windows.Client.Vista.SQLProvider (DataSourceModuleType)

Element properties:

Member Modules:

Source Code:

<DataSourceModuleType ID="Microsoft.Windows.Client.Vista.SQLProvider" Accessibility="Internal" RunAs="SCDW!Microsoft.SystemCenter.DataWarehouse.ActionAccount">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Query" type="xsd:string"/>

  </Configuration>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource TypeID="System!System.Scheduler" ID="Scheduler">

          <Scheduler>

            <SimpleReccuringSchedule>

              <Interval Unit="Seconds">604800</Interval>

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ProbeAction ID="OleDbProbe" TypeID="System!System.OleDbProbe">

          <ConnectionString>Server=$Target/Property[Type="SCDW!Microsoft.SystemCenter.DataWarehouse"]/MainDatabaseServerName$;Database=$Target/Property[Type="SCDW!Microsoft.SystemCenter.DataWarehouse"]/MainDatabaseName$;Provider=SQLOLEDB;Integrated Security=SSPI</ConnectionString>

          <Query>$Config/Query$</Query>

          <GetValue>true</GetValue>

          <OneRowPerItem>true</OneRowPerItem>

        </ProbeAction>

        <ConditionDetection ID="Filter" TypeID="System!System.ExpressionFilter">

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>//Columns/Column[1]</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>1</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="Filter">

          <Node ID="OleDbProbe">

            <Node ID="Scheduler"/>

          </Node>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>System!System.OleDbData</OutputType>

</DataSourceModuleType>