CHAPTER 4

image

SQL Server Source Patterns

In the first section of this book, we looked at patterns focused on the Control Flow area of SQL Server Integration Services, including metadata, workflow execution, and scripting. The second section focuses on the Data Flow area of SQL Server Integration Services. This and the following chapters will discuss source, transformation, and logging patterns in the pipeline area of an Integration Services package.

Integration Services supports a wide variety of sources, including SQL Server, Oracle, and SAP. In addition, developers and third-party vendors have the ability to create custom sources for providers ...

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.