SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations

SQL Server Integration Services (SSIS) is built to move and transform data from various sources to destinations. As with any flexible software language or platform, there are many ways to accomplish the same tasks using SSIS.

The flip-side of flexibility is complexity – this holds for SQL Server Integration Services, as well as all software. Balancing flexibility with ease of use is a delicate tradeoff, easily missed on either side of the equation. Built as a data integration tool, SSIS lends itself to extension and integration by way of scripting, custom components, and the ability to execute external processes. In this whitepaper, we will describe some SQL Server Integration Services development use cases and some innovative solutions provided by expressor software.

Enter Popup Content Here