Breaking Out Result Sets With Biml

Kevin Feasel

2016-11-09

Biml

Ben Weissman uses OFFSET-FETCH to split out large tables into separate files:

This post uses objects and annotations from our previous post “Export to Flatfiles with Biml”. Please use the code from that post as a prerequisit.

In the previous post, we’ve exported the whole database to flatfiles with one file per table. But what if we want to split large tables into multiple files? One easy way to do that would be to retrieve the data using OFFSET-FETCH NEXT from SQL Server.

Read on for more.

Related Posts

Using Biml With Oracle

Shannon Lowder shows us that you can write Biml to connect to an Oracle database as well: Next, I wanted to build a package from Biml. A package that uses a connection to my Oracle instance.  Defining connections to Oracle in Biml is similar to every other connection you’ve ever defined in Biml (lines 3-12). […]

Read More

Grouping Sets Of Tables In Biml ETL Loads

Ben Weissman puts together clusters of tables for data loads: The table meta.containers could technically also be a temporary table. We’ve decided against that so you can see what’s happening behind the scenes. Let’s focus on the meta.tables table for now. It has three columns: – TableName – guess what we’ll store in there – […]

Read More

Categories

November 2016
MTWTFSS
« Oct Dec »
 123456
78910111213
14151617181920
21222324252627
282930