DB2 Source Patterns - SQL Server Integration Services Design Patterns - page 178

Figure 6-8 . OLE DB Source Editor with dynamic query properties
When this package runs, use a package parameter to pass in the correct environ-
ment schema name. The expression on the query variable will be set to the new query
and execute correctly. Make sure to set the ValidateExternalMetadata prop-
erty on the OLE DB source to False to ensure that the package will validate success-
fully.
Summary
This chapter has covered many of the patterns necessary to connect to the different
types of the IBM DB2 database. You've learned how to determine what type of DB2
database you own, how to pick the appropriate provider, and different ways of querying
the database. Note that sometimes organizations go a different route when dealing with
DB2: exporting the data into a file and then loading the file using SSIS. This is a per-
fectly valid option and might make sense for you if you have network latencies or
problems with connectivity to your DB2 database. If you decide to go this route in-