Integration Services Sources

A deadlock was detected while trying to lock variables in SSIS

Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error

Control Flow Tasks

Executing SSIS Packages Using DTExec

Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.

SSIS Precedence

From Zero to SSIS! Learning SQL Server Integration Services

Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. This is a paid event. More details inside.

Creating packages in code - Workflow

This is just a quick one prompted by a question on the SSIS Forum, how to programmatically add a precedence constraint (aka workflow) between two tasks. To keep the code simple I’ve actually used two Sequence containers which are often used as anchor points for a constraint. Very often this is when you have task that you wish to conditionally execute based on an expression.

Implementing SSIS Package Configurations

Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content.

SQL Server 2008,Windows 2008 x64 and Excel

Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.

Achieve Spatial Data Support in SSIS

Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.