Passing data between packages—Raw Source and Destination
Staging is a very familiar terminology when working on Data Integration and ETL Tools. Staging in simple words means a space for storing data temporarily. In between the ETL steps, there are many times where staging plays an important role for data transfer and ETL cannot be implemented without staging.
The Raw Files format provided by SSIS is a binary format especially for SSIS which stores data in a binary format with special headings related to SSIS metadata. This binary format provides the fastest way to read and access data compared to other staging areas. Raw Source and Destination provides a way to read data from Raw File and Store data there respectively.
In this recipe, we will load data from a source into a Raw File for the purpose of staging. Suppose that this staging Raw File is used after some Control Flow Tasks or after some hours, then we use the Raw File as the source and extract its data to a destination.
