September 2012
Intermediate to advanced
444 pages
12h 17m
English
book
SQL Server 2012 Integration Services Design Patterns
by Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford
Content preview from SQL Server 2012 Integration Services Design Patterns
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
CHAPTER 6
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 ...