Tuesday, September 25, 2007 - Posts

SSIS Pipeline performance changes in Katmai

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Pipeline performance changes in Katmai
The new RSS feed is here

The SSIS pipeline is being changed in Katmai to allow more parallel processing. For any multi processor machine this should result in a performance improvement.

Essentially each arrow in your data flow can now have an active buffer, where as in SQL 2005 you only have 1 active buffer from the source to the next asynchronous component. Many people put in a UNION ALL component (which is asynchronous) to allow more buffers to be used.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Pipeline performance changes in Katmai

posted Tuesday, September 25, 2007 10:11 PM by SimonSabin with 0 Comments

SSIS change to pipeline for custom components

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS change to pipeline for custom components
The new RSS feed is here

If you've written your own custom components then you should read this post on the SSIS forum about a possible change to the pipeline that may affect your component.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2190281&SiteID=1&mode=1

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS change to pipeline for custom components

posted Tuesday, September 25, 2007 10:01 PM by SimonSabin with 0 Comments

SSIS Dates aren't very precise

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Dates aren't very precise
The new RSS feed is here

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Dates aren't very precise

posted Tuesday, September 25, 2007 9:33 PM by SimonSabin with 0 Comments