THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS » dataflow » sql server integration services   (RSS)
  • Dataflow mechanics [SSIS]

    Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson but that ended in August 2009 when I left EMC. There is a lot of (arguably) 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 ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 25, 2011
  • [SSIS] OnPipelineRowsSent event

    Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson 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
  • Why is there no CROSS JOIN component in SSIS?

    I saw an interesting question on the SSIS MSDN forum yesterday where someone was asking how to do a cartesian product (i.e. a CROSS JOIN) in a SQL Server Integration Services (SSIS) dataflow. Links were provided to various articles that cover this (see Performing a Cross Join (Cartesian Product) in SSIS which explains how you can fool the Merge ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 8, 2011
  • Merge Join component sorted outputs [SSIS]

    One question that I have been asked a few times of late in regard to performance tuning SSIS data flows is this: Why isn’t the Merge Join output sorted (i.e.IsSorted=True)? This is a fair question. After all both of the Merge Join inputs are sorted, hence why wouldn’t the output be sorted as well? Well here’s a little secret, the Merge Join ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 31, 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
  • SSIS gotcha: Beware of multiple outputs from a synchronous script component

    A few days ago I was alerted to a peculiarity of SSIS’s Script Component that I believe people need to be aware of. Its a peculiarity that can rear its head when your script component is synchronous and has multiple outputs. Here’s an example of a dataflow that contains such a component: Some things to note about this dataflow that you ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 4, 2010
  • Inequality joins, Asynchronous transformations and Lookups : SSIS

    It is pretty much accepted by SQL Server Integration Services (SSIS) developers that synchronous transformations are generally quicker than asynchronous transformations (for a description of synchronous and asynchronous transformations go read Asynchronous and synchronous data flow components). Notice I said “generally” and not “always”; there are ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 14, 2010
  • Destination Adapter Comparison : SSIS Video Nugget

    In this, my latest video nugget, I demonstrate and compare three ways that you can insert data into a SQL Server table from the SSIS DataFlow: OLE DB Destination without Fast Load OLE DB Destination with Fast Load SQL Server Destination The demo peels back the covers to see how these three methods actually ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 2, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement