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
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
The DTS component of SQL Server 2000 was a redistributable client component. This mean anyone with a SQL Server Client Access Licence (CAL) could not only connect to SQL Server in the normal manner, but that could also run DTS packages on their machine. Since DTS and SSIS have no client server, or remote execution… Continue reading Redistribute SSIS
What is Validation?
Some questions keep popping up about validation and I thought I'd try to clarify it a bit. What is Validation I've never seen a good definition for what validation in IS is supposed to be or what it's supposed to do anywhere. There is a lot of discussion about what components do when validating, but… Continue reading What is Validation?