A collection of a my BIML / SSIS scripts and examples. BIML (Business Intelligence Markup Language) is a product of varigence: http://varigence.com/
Wednesday, September 12, 2012
BIML Check Database Integrity
Example file for creating a Check DataBase Integrity SSIS 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>
</Connections>
<Packages>
<Package Name ="Maintenance.CheckDataBaseIntegrity" ConstraintMode="Linear">
<Annotations>
<Annotation>
File: Maintenance.CheckDataBaseIntegrity.biml
Demo biml for setting up a Check DataBase Integrity package
Enviroment:
DB: MS-SQL2012
BIML: 1.6 VS2010 BIDS Helper
(c) John Minkjan biml101.blogspot.com
</Annotation>
</Annotations>
<Tasks>
<CheckDatabaseIntegrity
Name="CDI Adventureworks"
ConnectionName="CnAdoAdventureWorks2012"
DatabaseSelectionMode="Specific" >
<Databases>
<Database>AdventureWorks2012</Database>
</Databases>
</CheckDatabaseIntegrity>
</Tasks>
</Package>
</Packages>
</Biml>
Till Next Time
Labels:
ALL POSTS,
BIDS,
BIML,
BIMLSCRIPT,
CDBI
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment