Biml And Metadata

Ben Weissman provides an example of using metadata to drive conditional data loading:

Now that we’ve defined connections, databases and schemas we still need to add our table metadata.

We’re going to do that by looping across all our databases marked as a source in Biml, retrieving the list of required tables from SQL (located in View vMyBimlMeta_Tables) and creating a table tag for each table which will also reference back to the corresponding target system. That also allows us to use the same table names multiple times. Again, we’ll store some additional data in annotations.

This is an interesting concept.  Check it out.

Related Posts

Unboxing ISPACs

It’s an early Christmas for Richie Lee: The first file that we’re going to look at is the [Content_Types].xml file, and this is the file that confirms that the ZipPackage class is used. There’s an article here that is ten years old but is still valid (scroll down to the System.IO.Packaging INcludes Zip Support to read up on this.) […]

Read More

SSIS In Azure

Richie Lee reports that SQL Server Integration Services is now available as a service in Azure: I’ve written about it elsewhere in greater depth, but here are the headlines: It makes use of SSIS Scale Out, which was released as part of SQL Server 2017. Although it is based on SSIS Scale Out, you can’t actually configure […]

Read More

Categories

August 2016
MTWTFSS
« Jul Sep »
1234567
891011121314
15161718192021
22232425262728
293031