O'Reilly logo

SQL Server Integration Services Design Patterns, Second Edition by Michelle Ufford, Jessica Moss, Matt Masson, Tim Mitchell, Andy Leonard

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 6

image

DB2 Source Patterns

In a previous chapter you learned about patterns related to SQL Server sources. In this chapter, we 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 we will discuss, as well as how to use each database as an Integration Services source.

As we 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 to take the additional first step of determining ...

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