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?
Upgrading SSIS Custom Components for SQL Server 2012
Having finally got around to upgrading my custom components to SQL Server 2012, I thought I’d share some notes on the process. One of the goals was minimal duplication, so the same code files are used to build the 2008 and 2012 components, I just have a separate project file. The high level steps are… Continue reading Upgrading SSIS Custom Components for SQL Server 2012
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
SSIS Field Notes – SQLBits 7 Presentation
Here are the slides from my session SSIS Field Notes presented at SQLBits 7 in York earlier this month – SSIS Field Notes – Darren Green.pptx On a similar theme, the video of my session Design patterns for SSIS Performance from is now available. You heard it here first! I know that this because I’ve… Continue reading SSIS Field Notes – SQLBits 7 Presentation
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
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… Continue reading Creating packages in code – Workflow
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
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
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?
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)