SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS

In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and preventing an out of memory exception. We describe how to load data in batches to avoid placing a large amount of data into memory. This article is the first in the SSIS Tips and Tricks series which aims to illustrate some best practices.