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