Importing Biml Metadata from Excel

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 Excel

One 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 fileBiml file, or Excel Spreadsheet in order to create new extracts.

The final post in the series contains quite a bit of code, too.

Related Posts

Importing Biml Metadata from Excel

Kevin Feasel

2019-06-24

Biml

David Stein shows how you can take table and column data from Excel and use it to populate Biml flows: Excel Spreadsheets as a metadata source have a lot going for them.– Everyone uses Excel and is comfortable with it.– Excel is incredibly customizable and versatile.– Excel offers data validation and filtering. For these reasons, […]

Read More

Using Biml to Retrieve Query Metadata

Kevin Feasel

2019-06-17

Biml

David Stein shows how you can use the GetQuerySchema() function in Biml to retrieve metadata for a query: This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so. The GetQuerySchema method provides an excellent way to import metadata […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

July 2019
MTWTFSS
« Jun  
1234567
891011121314
15161718192021
22232425262728
293031