Be aware of Sorts in SSIS

Be aware of Sorts in SSIS!
SSIS will first retrieve the entire dataset and after that perform the sorting.

A mistake I made was that I didn’t drop the Clustered Index on the destination table (ORDER BY DESC…bummer).
Dropped it, ran the initial load and re-created the Clustered Index afterwards 😉

Advertisements

One thought on “Be aware of Sorts in SSIS

  1. Pingback: Link Resource # 56 : May 24 – May 30 « Dactylonomy of Web Resource

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