Marcin Policht

In our recent articles we have been discussing different methods of facilitating code reusability in SQL Server 2012 Integration Services. So far, we have demonstrated how to leverage variables (which have been available in earlier versions of the product) as well as newly introduced parameters to accomplish this objective. Now we will extend the scope […]

In our recent articles published on this forum, we have been discussing different methods of assigning values to properties of SQL Server 2012 Integration Services packages and their components, focusing in particular on variables and parameters. As we pointed out, the purpose and configuration of variables have not changed significantly since the previous version of […]

In one of our recent articles published on this forum, we have described how variables can be used to simplify development and maintenance of SQL Server 2012 Integration Services packages and projects. As we have pointed out, variables serve a dual role. Their primary purpose is to provide runtime storage for values utilized by SSIS […]

In the recent articles published on this forum, we have been presenting new features of SQL Server 2012 Integration Services. Our presentations have been based so far on the Release Candidate 0 (RC0) of the product, offered as a free download since mid-November 2011. Now we can take advantage of the final version incorporated into […]

In one of our recent articles published on this forum, we provided a comprehensive listing of new and enhanced features introduced in the Integration Services incorporated into soon-to-be released SQL Server 2012. In case you are interested in exploring them in-depth, we intend to examine each of them in detail in upcoming presentations. However, for […]

Extraction, transformation, and loading’s primary objective is to facilitate moving data between its source and destination while subjecting it to arbitrary modifications, and has been an integral part of the Microsoft SQL Server product line for a number of years.  In SQL Server 7.0 and 2000, such capabilities have been provided by Data Transformation Services […]

SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typically there are refinements or caveats that should be taken into account as part of their […]

In our recent articles published on this forum, we have been discussing Business Intelligence based features incorporated into SQL Server 2008 R2 Integration Services. Continuing this approach, we will now turn our attention to two closely related Data Flow components – Row Sampling Transformation and Percentage Sampling Transformation, which provide data sampling functionality. This functionality […]

In one of our recently published articles, we have described characteristics and operations of Partition Processing Data Flow Destination, which illustrates one of the many aspects of support for Business Intelligence-related features built into SQL Server 2008 R2 Integration Services. In particular, this SSIS component is capable of performing direct data load from a fact […]

The primary purpose of Integration Services technology is to deliver extraction, transformation, and loading functionality that supports core features of SQL Server database management systems. However, there are numerous scenarios where its role involves interaction with components that provide Business Intelligence-related features. In this article, we will discuss one such scenario, which leverages built-in SSIS […]

In the recent tutorials published on this forum, we have been discussing the primary characteristics of Slowly Changing Dimension (SCD) Data Flow Transformation in SQL Server 2008 R2 Integration Services. So far, we have covered its Changing Attribute and Historical Attribute options (corresponding to Type 1 and Type 2 changes) as well as support for […]

In one of the recent tutorials published on this forum, we described characteristics of Slowly Changing Dimension methodology, focusing in particular on its implementation in SQL Server 2008 R2 Integration Services. Its wizard-driven transformation considerably simplifies configuration of all relevant Data Flow components, although it does not offer full support for all existing change types. […]