jump to navigation

SSIS Transformation and Execution Tree March 8, 2009

Posted by Arshad Ali in SQL Server Integration Services, SSIS, SSIS 2008.
trackback

SSIS Transformation and Execution Tree

There are two main concepts related to SSIS internals which need to be understood before we deep dive in optimizing SSIS packages.
Transformation – There are different kinds of tranformation in SSIS which overall impacts the performance of SSIS.
Execution Tree – At run time, the data flow engine breaks down Data Flow task operations into execution trees. Execution trees are enormously valuable in understanding buffer usage.

I have written an article covering different kinds of transformation and how data flow task operations are divided into execution trees.

Refer this link for more details.

http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_2_p1.aspx

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: