Intelligent Conditional Split in an SSIS Package

Conditional Split is one of the most commonly used transforms in any SSIS Package development routine. The limitation with conditional split is that any record that satisfies the first condition from the conditions list is routed to its corresponding path exclusively. In a logical sense, a record might satisfy more than one condition and one might want the record to be routed to all paths for processing, but with the Conditional Split transform this is not possible. We need a more intelligent conditional split where we can selectively route the records to more than one output path. In this tip we will look at how to facilitate this intelligent conditional split.

Using SSIS Logging to Resolve Runtime Errors and Performance Issues

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.

Protect the Excel files generated by SSIS package-Part I

It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed

SSIS Events and Handlers

Explore how SQL Server 2008 Integration Services' events are triggered during package execution and the ability to react to their outcome through event handlers.

SSIS Package Execution

SSIS Control Flow

Top 10 SQL Server Integration Services Best Practices

Learn the top 10 best practices for large scale SSIS packages from a real world DBA.

SSIS Scripting

Automatic Restart of SSIS packages after Failover or Failure

SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.

Parsing an ADO result set into a comma separated string in SSIS

This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.