THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » dataflow » ssis   (RSS)
  • [SSIS] OnPipelineRowsSent event

    Once upon a time I blogged at but that ended in August 2009 when I left EMC. There is a lot of valuable content over there however certain events in the past leave me concerned that that content is not well cared for and I don't have any confidence that it will still exist in the long term. Hence, I ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 19, 2011
  • Always use dtexec.exe to test performance of your dataflows. No exceptions.

    Earlier this evening I posted a blog post entitled Investigation: Can different combinations of components effect Dataflow performance? where I compared the performance of three different dataflows all working to the same overall goal. I wanted to make one last point related to the results but I thought it warranted a blog post all of its ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2011
  • Investigation: Can different combinations of components affect Dataflow performance?

    Introduction The Dataflow task is one of the core components (if not the core component) of SQL Server Integration Services (SSIS) and often the most misunderstood. This is not surprising, its an incredibly complicated beast and we’re abstracted away from that complexity via some boxes that go yellow red or green and that have some lines drawn ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2011
  • Don’t turn the dataflow into a cursor [SSIS]

    I saw a thread on the SSIS forum today that went something like this: I have the following dataset: AccountNo Date DailyMovement 00000001 28/08/2010 10 00000001 29/08/2010 5 00000001 ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 31, 2010
Privacy Statement