0xC0017011 and other error messages – what is the error message text?

Recently there was a bug raised against BIDS Helper which originated in my Expression Editor control. Thankfully the person that raised it kindly included a screenshot, so I had the error code (HRESULT 0xC0017011) and a stack trace that pointed the finger firmly at my control, but no error message text. The code itself looked… Continue reading 0xC0017011 and other error messages – what is the error message text?

Using the Script Component as a Conditional Split

This is a quick walk through on how you can use the Script Component to perform Conditional Split like behaviour, splitting your data across multiple outputs. We will use C# code to decide what does flows to which output, rather than the expression syntax of the Conditional Split transformation. Start by setting up the source.… Continue reading Using the Script Component as a Conditional Split

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… Continue reading A deadlock was detected while trying to lock variables in SSIS

Published
Categorised as General

SSIS Expression Editor & Tester

Available on GitHub SSIS Expression Editor & Tester. (Links updated, Sep 2019.) About five years ago I developed my own expression editor control. It first got used in our custom tasks as the MS editor didn’t become available until SQL 2005 SP1, but even then it had some handy features I preferred. For example resizable… Continue reading SSIS Expression Editor & Tester

Published
Categorised as Tools

Data Profiling without SSIS

Strangely enough for a predominantly SSIS blog, this post is all about how to perform data profiling without using SSIS. Whilst the Data Profiling Task is a worthy addition, there are a couple of limitations I’ve encountered of late. The first is that it requires SQL Server 2008, and not everyone is there yet. The… Continue reading Data Profiling without SSIS

Published
Categorised as General

Have you used the ExecutionValue and ExecValueVariable properties?

The ExecutionValue execution value property and it’s friend ExecValueVariable are a much undervalued feature of SSIS, and many people I talk to are not even aware of their existence, so I thought I’d try and raise their profile a bit. The ExecutionValue property is defined on the base object Task, so all tasks have it… Continue reading Have you used the ExecutionValue and ExecValueVariable properties?

Published
Categorised as Tasks

Design Patterns for SSIS Performance (Presentation)

Here are the slides from my session (Design patterns for SSIS Performance) presented at SQLBits VI in London last Friday. Slides – Design Patterns for SSIS Performance – Darren Green.zip (86KB) It was an interesting session, with some very kind feedback, especially considering I woke up on Friday without a voice. The remnants of a… Continue reading Design Patterns for SSIS Performance (Presentation)