Marcin Policht

Just like its predecessors, SQL Server 2008 R2 Integration Services offers a variety of methods that allow you to extend the range of its capabilities beyond those traditionally associated with data management. These auxiliary features tend to be extremely helpful when automating tasks supporting extraction, transformation and loading (ETL) activities. In this article, we will […]

While using Microsoft Office Excel to store a variety of semi-structured data tends to be more economical and convenient than SQL Server, it lacks data mining and data warehousing capabilities. This article explores importing spreadsheets onto SQL Server and taking advantage of Office Automation through managed code running inside a Script Task. Despite the technological […]

SQL Server 2008 Integration Services offers a variety of ways to access Excel-based data. The most popular ones (such as Export and Import Wizard, Data Conversion Transformation, or Derived Column Transformation, which we have already presented on this forum) are quite straightforward to implement, however their simplicity comes at the cost of limited flexibility. If […]

SSIS offers extensive logging capabilities, allowing you to record predefined events raised by packages and their components. These same configuration settings can be leveraged in Script Task, but you also have the option of triggering and tracking events in a considerably more customizable manner. This article explores features that provide this flexibility. SQL Server 2008 […]

Script Task, included in SQL Server Integration Services (SSIS), offers an extensive degree of flexibility that allows you to deal with non-traditional data stores and customize the processing of standard sources of data by leveraging their unique characteristics. Read on to learn more… As we have demonstrated in recent articles published on this forum, Script […]

When working with Script Task of SQL Server 2008 Integration Services, it is important to ensure that your custom code complies with the most elementary programming practices. Learn how to handle unexpected errors that interfere with the successful execution of your code. While SQL Server 2008 Integration Services greatly simplify the creation of packages by […]

One of the most distinguishing characteristics of Control Flow Script Task available in SQL Server 2008 Integration Services is its flexibility. This article demonstrates some of these capabilities by describing an approach that employs the Script Task to query data residing in an Active Directory domain database. One of the most distinguishing characteristics of Control […]

SQL Server 2008 Integration Services contains an assortment of predefined Control Flow tasks designed to carry out specific types of actions. Collectively, they cover a wide range of scenarios; however, their specialized nature sometimes turns out to be overly restrictive. This article explains how to accommodate these custom requirements by employing the considerably more flexible […]

Runtime errors and performance issues can be difficult to identify and resolve. One of the primary methods that assist with their resolution involves generating logs, which contain records of events taking place during code execution. This article provides a comprehensive overview of logging options available in SQL Server 2008 R2 Integration Services. In general, software […]

Explore how SQL Server 2008 Integration Services’ events are triggered during package execution and the ability to react to their outcome through event handlers. In its most basic form, creating SQL Server 2008 Integration Services packages using Business Intelligence Development Studio is a relatively straightforward process that leverages Studio’s intuitive (based on Visual Studio design […]

The confidentiality of SQL Server 2008-based Integration Services packages can be protected by encrypting their content or controlling access to them through restrictive permissions. Additionally, you have the option of detecting whether their code has been modified since its original release. This article discusses how this can be accomplished by leveraging digital signatures. As we […]

While it is very common to store SSIS packages created using SQL Server Business Intelligence Development Studio in the file system, it is important to realize that there are other options. This article provides a comprehensive overview of all of the options, including their benefits and drawbacks, focusing on their ability to protect package content […]