<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Annotations>
		<Annotation>
			File: Transfer.DataBase.Objects.biml
			Demo on transferring database objects
			between MSSQL environments
			Enviroment:
			DB: MS-SQL2012
			BIML: 1.6 VS2010 BIDS Helper
			(c) John Minkjan biml101.blogspot.com
		</Annotation>
	</Annotations>
	<Connections>
		<SqlServerManagementConnection
            Name="SSMCLocalHostMSSQL2012"
            SqlServerName=".\MSSQL2012"
            UseWindowsAuthentication="true"></SqlServerManagementConnection>
	</Connections>
	<Packages>
		<Package Name ="Transfer.DataBase.Objects" ConstraintMode="Linear">
			<Tasks>
				<TransferSqlServerObjects
                    Name ="TransferSqlServerObjects"
                    SourceConnectionName="SSMCLocalHostMSSQL2012"
                    SourceDatabase="AdventureWorks2012"
                    DestinationConnectionName="SSMCLocalHostMSSQL2012"
                    DestinationDatabase="AdventureWorksDW2012"
                    DropObjectsFirst="true"
                    CopyData="true"
                    CopyAllTables="false">
					<Annotations>
						<Annotation>
							Notation for tables:
							[schema].[TableName]
							(including bracktes}
							Target schema must exist!
						</Annotation>
					</Annotations>
					<Tables>
						<Table>[HumanResources].[Department]</Table>
						<Table>[HumanResources].[Employee]</Table>
						<Table>[HumanResources].[EmployeeDepartmentHistory]</Table>
					</Tables>
				</TransferSqlServerObjects>

			</Tasks>
		</Package>
	</Packages>
</Biml>