O'Reilly logo

Professional Microsoft SQL Server 2012 Integration Services by Chris Rock, Mike Davis, Jessica M. Moss, Erik Veerman, Brian Knight

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

Chapter 21

Using SSIS with External Applications

WHAT’S IN THIS CHAPTER?

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

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