Monthly Archives: February 2012

Resources for SSIS Performance Best Practices

Simple post today. Here are a number of links to resources that I reference in my Performance Design Patterns presentation. Top 10 SQL Server Integration Services Best Practices The Data Loading Performance Guide Integration Services: Performance Tuning Techniques We Loaded 1TB in 30 Minutes with SSIS, and So Can You SSIS 2005: A Strategy for … Continued

CDC Control Task Operations

CDC Control Task Operations

The CDC Control Task is used for a number of different operations. This post lists each of those operations, and briefly describes when to use them. Mark initial load start This operation is used when executing an initial load from an active database without a snapshot. It is invoked at the beginning of an initial-load … Continued

Thoughts on Branching Strategies for SSIS Projects

A question came in recently from a customer about branching strategies for SSIS projects. Their development team has been using SSIS for years, but have not been using any form of source control software up until now. They felt that the package format improvements in SQL Server 2012, which were focused on making it possible … Continued

Speaking at SQL Saturday #111 | Atlanta

Speaking at SQL Saturday #111 | Atlanta

Wow, what a lineup for SQL Saturday #111. I’m still amazed and honored anytime I’m on a speaker list of this caliber! I’ll be co-presenting a pre-con event (full day training) with Andy Leonard on April 13th, and talking about SSIS in SQL Server 2012 as part of the main event. Rumor has it that … Continued

Exit Codes, DTEXEC, and SSIS Catalog

DTEXEC has two execution modes when running packages in the SSIS Catalog. By default, the process runs asynchronously – the package execution is scheduled on the server, and DTEXEC returns immediately. DTEXEC does not wait for the package execution to complete. In this case, %ERRORLEVEL% would represent whether the package execution was created successfully, and … Continued

Queries for Data Flow Component Performance in SQL 2012

Queries for Data Flow Component Performance in SQL 2012

The built-in SSIS Catalog reports in SSMS show a breakdown of task and component performance of a package execution when you run with a logging level of “Performance”. For a more detailed or customized view, you can query the catalog tables directly. The key table to get data flow performance information is [catalog].[execution_component_phases]. Here are … Continued