David Stein wraps up a series on using Biml to load flat files:
Make sure you read and understand the concepts in each of the following articles before tackling this one.
– Import Biml Metadata with GetQuerySchema
– BimlScript Code Nuggets and Mad Libs
– Import Biml Metadata Directly from ExcelOne of the primary issues I’ve mentioned in each of the preceding short cut steps is a lack of real automation. Since we didn’t have our metadata externalized, we needed to copy/paste some object, T-SQL file, Biml file, or Excel Spreadsheet in order to create new extracts.
The final post in the series contains quite a bit of code, too.