Creating AstTableNodes

Kevin Feasel

2016-08-23

Biml

Ben Weissman has a quick post in which he shows how to convert a .NET DataTable into a Biml AstTableNode:

This extension method will convert a datatable into an AstTableNode.

Remarks:
The datatype mapping is not complete

The code itself is straightforward; it’s converting and mapping. ¬†Check it out.

Related Posts

Remote Code Execution with CallBimlScriptContent

Bill Fellows describes the ability to execute code in Biml from a remote source with the CallBimlScriptContent function: CallBimlScriptContent¬†was introduced with the migration from Mist to BimlStudio. Why is this cool? You do not have to use files sitting on your computer as the source for your Biml. As long as you can reconstitute the […]

Read More

Generating SQL With Biml

Cathrine Wilhelmsen shows us you can do a lot more with Biml than just generating SSIS packages: This actually happened to me in a previous job. We had a fairly complex ETL solution for the most critical part of our Data Warehouse. Many SSIS packages, views, and stored procedures queried the tables that were replicas […]

Read More

Categories

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