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 ...