in2bi

/*
  Truncate all tables in a database, by:
  - dropping all foreign key constraints
  - truncating all the tables
  - recreating the dropped foreign key constraints
*/

DECLARE @DropConstraints nvarchar(max)    
DECLARE @TruncateTables nvarchar(max)     
DECLARE @RecreateConstraints nvarchar(max)           

in2bi

<Biml xmlns="http://schemas.varigence.com/biml.xsd">  
  <#  
      string xBiml = RootNode.GetBiml();  
      XmlDocument xmlDoc = new XmlDocument();  
      xmlDoc.LoadXml(xBiml);  
      string sFile = @"C:\temp\myBimlFile.xml";  

      xmlDoc.Save(sFile);  
   #> 
</Biml>  

in2bi

--1. Create database
CREATE DATABASE CDCTest;
GO

--2. Create CDC table using AdventureWorksDW2012 database
USE  CDCTest 
GO

SELECT * 
INTO DimDepartmentGroup_CDC

in2bi

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <AdoNetConnection Name="Source" 
                      ConnectionString="Data Source=.;Initial Catalog=CDCTest;Integrated Security=True;" 
                      Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
                      CreateInProject="true" />
     <AdoNetConnection Name="Destination" 
                      ConnectionString="Data Source=.;Initial Catalog=CDCTest;Integrated Security=True;" 
                      Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
                      CreateInProject="true"/>

in2bi

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <AdoNetConnection Name="Source" 
                      ConnectionString="Data Source=.;Initial Catalog=CDCTest;Integrated Security=True;" 
                      Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
                      CreateInProject="true" 
                      />
     <AdoNetConnection Name="Destination" 
                      ConnectionString="Data Source=.;Initial Catalog=CDCTest;Integrated Security=True;" 
                      Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"