Welcome to EMC Consulting Blogs

In my blog entry Custom Logging Using Event Handlers from June 2005 I described an easy technique for using SSIS eventhandlers to get more useful logging information from your packages than using the out-of-the-box logging providers and up to now it has proved to be one of my most popular blog entries. With the introduction of the ...

  That’s what I twittered recently upon first opening up Release Candidate 0 of SQL Server 2008. You may remember that back in March of this year I told you about a new feature that would be appearing in a future CTP; namely that a container would provide information about its parent container. Hence if you peer into the depths of this ...

In the dim and distant past I wrote a blog entry that attempted to explain the concept of containers in an SSIS package. Following a post from Paul Pisarek this evening on the SSIS forum I thought it might be beneficial to expand on the concept a little. Hopefully after reading the blog entry linked to above you are familiar with how a package ...

DTS 2000 packages contained a hierarchical view of a package known as the DTS object model. The replacement for DTS, SQL Server Integration Services, has a similar concept of a package being represented as a hierarchy but it is not as rigid as before. In DTS 2000 a new package already contained a hierarchy which included a task ...