USE AdventureWorks2012
GO

INSERT ETLConfig.biml.TableLoadColumn
SELECT (SELECT TableLoadID 
		FROM ETLConfig.biml.TableLoad 
			WHERE ProcessName = 'ProductionInfo' 
			AND SourceTableName = 'Product'
)
	, name, name
	, CASE WHEN name IN ('ProductID', 'rowguid', 'ModifiedDate') THEN 'Ignore' ELSE 'Map' END
FROM sys.columns	
WHERE OBJECT_NAME(object_id) = 'product'
ORDER BY column_id
