Chapter 21

Using SSIS with External Applications


  • Interacting with Office applications
  • Interacting with ASP.NET applications
  • Interacting with Windows .NET applications
  • Executing packages with T-SQL

SQL Server 2012 Integration Services accepts data from nearly any source and presents output, including ADO.NET data sets and SSIS data readers that are consumable by external applications. These features enable SSIS to sink and source external applications with ease. In this chapter, you take a look at three examples of external applications that utilize SSIS. This chapter is not intended to provide an exhaustive look at all possible combinations of external interface with SSIS, but rather to provide a sampling of some available functionality.

SSIS is flexible and configurable, so there are many ways to approach interaction with external applications. This book is rife with examples, including the following:

  • Sources and Destinations: These are implicit objects inside SSIS that provide connectivity to data sources and destinations.
  • Scripting: Arguably provides the most flexibility when interacting with external applications. The Script Component still comes in three flavors: Source, Destination, or Transformation. You can use C# and VB.NET with it. The .NET Framework version for developing in this component is 4.0. See Chapter 9 for an example and more information.
  • Employ a methodology: Chapter 16 provides an introduction to software development life cycles ...

Get Professional Microsoft SQL Server 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.