Marcin Policht

In this article of our series dedicated to SQL Server 2005 Integration Services, we are continuing coverage of features provided by XML Control Flow task. So far, we have discussed validate, XSLT, and XPATH options (configured by assigning appropriate values to OperationType property in the XML Task Editor window). The remaining features of SSIS XML […]

In the previous article of our series dedicated to SQL Server 2005 Integration Services, we started discussing various types of actions that can be performed using XML Control Flow task, covering its Validate and XSLT options. We will continue this subject by focusing our attention on the next operation type called XPATH. As mentioned earlier, […]

The importance of XML-based technologies is steadily increasing and this trend is reflected by a variety of new features in this category introduced in SQL Server 2005 Integration Services. One of the most prominent ones is the XML Control Flow task, which provides assistance with processing XML-formatted documents. In this installment of our series, we […]

In this installment of our series dedicated to SQL Server 2005 Integration Services, we will review a Web Service Control Flow task that exposes an infinite range of easily deployable features by leveraging capabilities present in the .NET Framework. We will explain the underlying principle of this methodology, describe characteristics of its SSIS implementation, and […]

Following presentation of the most popular Data Flow transformations in SQL Server 2005 Integration Services, we are revisiting the topic of Control Flow tasks, in order to make our coverage more complete. Among the most common tasks that have not yet been discussed in our series is the Send Mail task, which will be the […]

Extensive ETL (Extraction, Transformation, and Loading) capabilities that SQL Server 2005 Integration Services are based on, deliver such essential functionality as the combination and cleanup of data originating from heterogeneous sources or scheduling and coordination of activities that frequently take place beyond the boundaries of database management systems. While a substantial number of these features […]

Continuing our coverage of SQL Server 2005 Integration Services Data Flow components, we will present Derived Column transformation, which, while serving primarily an auxiliary role, should not be ignored, since it offers considerable flexibility and versatility combined with extreme ease of use. Its functionality is based on its ability to generate output data rows through […]

As we have demonstrated in the recent installments of our series, in addition to handling standard tasks associated with data processing (available also in legacy Data Transformation Services), SQL Server 2005 Integration Services offers some new, unconventional capabilities. Fuzzy Lookup and Grouping, covered in my two latest articles, help dealing with potentially erroneous data (by […]

Continuing the topic of data cleansing through applying approximate match algorithms, which we started in the most recent article of our series dedicated to SQL Server 2005 Integration Services, we will now present another Data Flow task in this category called Fuzzy Grouping. Unlike previously discussed fuzzy lookups, grouping does not rely on a reference […]

In the recent articles of our series dedicated to SQL Server 2005 Integration Services, we have been covering the most popular Data Flow components. The latest article focused on Lookup Transformation, which combines records from two sources based on exact match between their corresponding fields. This functionality, while very useful, depends to large extent on […]

Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, which we initiated in the previous installment of this series, we will focus now on the Lookup transformation. Its basic purpose is to combine data from two sources, by matching one or more of their fields (commonly used when populating fact tables […]

After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, ranging from its innovative architecture, through main package design principles, along with debugging and deployment techniques, to security and performance consideration, we will focus now on individual components that have more specialized, but very useful characteristics. We will start by discussing […]