O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required