DB2 Source Patterns

In the previous chapters in this section, you learned about patterns that relate to SQL Server and Oracle Sources. In this chapter, I will move on to patterns that relate to sourcing data from the IBM DB2 database. DB2 describes a variety of databases, so it is essential to learn about the different databases I will discuss, as well as how to use each database as an Integration Services source.

As I described in Chapter 4, setting up a source entails four different objects: connection manager, provider, source component, and a source component query. While this remains true for the DB2 database, you need the additional ...

Get SQL Server 2012 Integration Services Design Patterns now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.