USE ETLConfig
GO


INSERT biml.TableLoad

SELECT 'SalesInfo', 'AdventureWorks2012', 'HumanResources', 'Department', 'AdventureWorks2012_ODS', 'dbo', 'Department'
UNION ALL SELECT 'SalesInfo', 'AdventureWorks2012', 'HumanResources', 'Employee', 'AdventureWorks2012_ODS', 'dbo', 'Employee'
UNION ALL SELECT 'SalesInfo', 'AdventureWorks2012', 'Person', 'Person', 'AdventureWorks2012_ODS', 'dbo', 'Person'
UNION ALL SELECT 'SalesInfo', 'AdventureWorks2012', 'Sales', 'SalesOrderDetail', 'AdventureWorks2012_ODS', 'dbo', 'SalesOrderDetail'
UNION ALL SELECT 'SalesInfo', 'AdventureWorks2012', 'Sales', 'SalesOrderHeader', 'AdventureWorks2012_ODS', 'dbo', 'SalesOrderHeader'

INSERT biml.tableload 
VALUES ('ProductionInfo', 'AdventureWorks2012', 'Production', 'Product', 'AdventureWorks2012_ODS', 'dbo', 'Product')
