SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Using the Data Viewer Intelligently in SSIS Data Flows

If you've ever needed to debug a fairly complex Data Flow, you've probably wanted to take a peek at what data is moving through the flow at various points.  The data viewer in Integration Services is how you do that - but it has a major drawback.  You may be processing…

Read more

0 comments, 1,857 reads

Posted in Todd McDermid's Blog on 31 May 2010

The SSIS Data Flow is Like... an Automotive Assembly Line

When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to fall back on automotive metaphors.  No, I'm not a gearhead, and no, it doesn't work every time, but it does seem to be the first thing that pops in my…

Read more

0 comments, 413 reads

Posted in Todd McDermid's Blog on 27 May 2010