Get to know this core component of Microsoft SQL Server Integration Services—a vital part of a multi-platform database-access solution
by Tom Snyder
Editor’s Note: This article is excerpted from chapter 3 of Extract, Transform, and Load with SQL Server Integration Services--with Microsoft SQL Server, Oracle, and IBM DB2, by Thomas Snyder and Vedish Shah.
To build your own “database-agnostic” data access solution based on Microsoft SQL Server Integration Services (SSIS), you will need to understand several components, one of which is the SSIS Toolbox. Here we will introduce the SSIS Toolbox and then step you through some of the most commonly used elements or tasks from the SSIS Toolbox component, which are used to create an SSIS workflow.