Friday, September 14, 2012

BIML WMI Reader

Example file for creating a WMI Reader Package:
<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;Initial Catalog=AdventureWorks2012;Provider=SQLNCLI10.1;Integrated Security=SSPI;Connect Timeout=30;"
            RetainSameConnection="true">
        </OleDbConnection>
        <WmiConnection
            Name="WmiConnection"
            ServerName="\\localhost"
            UseWindowsAuthentication="true"
            Namespace="\root\cimv2" />
        <FileConnection
            Name="MyWMILoging"
            FilePath ="C:\WMILog.csv"
            FileUsageType="CreateFile">
        </FileConnection>
    </Connections>
    <Packages>
        <Package Name ="Config.WMIReader"
                 ConstraintMode="Linear"
                >
            <Annotations>
                <Annotation>
                    File: Config.WMIReader.biml
                    Demo biml for setting a WMI export to CSV
                    Enviroment:
                    DB: MS-SQL2012
                    BIML: 1.6 VS2010 BIDS Helper
                    (c) John Minkjan biml101.blogspot.com
                </Annotation>
            </Annotations>
            <Tasks>
                <WmiDataReader    Name="WMIReader" ConnectionName ="WmiConnection" >
                    <DirectInput>select * from WIN32_Process</DirectInput>
                    <FileOutput ConnectionName ="MyWMILoging"></FileOutput>
                </WmiDataReader>               
            </Tasks>
        </Package>
    </Packages>
</Biml>
Till Next Time

No comments:

Post a Comment