Sorting data in the SSIS Pipeline (Video)

by Allan Mitchell 29 May 2010 20:27

In this post I want to show a couple of ways to order the data that comes into the pipeline. a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs. One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.

Tags Sorting

Categories Data Flow | Transformations | Sources | Videos

Data Profiling without SSISStrangely enough for a predominantly SSIS blog, this post is all about how to perform data profiling...Creating packages in code - Flat File Source to OLE-DB Destination (SQL Server)This code sample programmatically creates a package that imports a text file into SQL Server, with a...CreationName for SSIS 2008 and adding components programmaticallyIf you are building SSIS 2008 packages programmatically and adding data flow components, you will pr...

Comments

6/7/2010 11:32:55 AM #

It wasn't made clear in the video - "IsSorted" does not actually sort data and it is not a way of sorting input data. It merely marks data as sorted. It is the developer's responsibility to make sure the inputs are sorted via previous stages or at the data source.

Suman

6/30/2010 12:30:31 PM #

Its great one....thanks

Shahrukh

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote * Required fields. Your email address will not shown, check the preview for what you see. We use it to send you notifications on new comments if you ask us to below.

Comment
Preview

Notify me when new comments are added

Popular this month

Posts	Hits
The Execute SQL Task	311
Looping over files with the Foreach Loop	239
Streaming Profiler Data Through StreamInsight	125
For Loop Container Samples	108
File Watcher Task	102
Multicast Transform and Threading in SQL Server 2008	101
Easy Package Configuration	88
Issuing Current Time Increments in StreamInsight (A Practical Example)	84
Row Number Transformation	81

RecentComments

SQL Server Editions and Integration Services (3)
Slot Online wrote: Dude.. I am not much into reading, but somehow I g... [More]
Looping over files with the Foreach Loop (51)
Ragan Martin wrote: This article is excellent just what I needed. R... [More]
For Loop Container Samples (17)
MSK wrote: Awesome example with excellent explanation ... Kee... [More]
A deadlock was detected while trying to lock variables in SSIS (2)
Todd McDermid wrote: To support Darren's statement that this method has... [More]
Optimising Lookups with the Cache Transform (Video) (1)
khaled wrote: good [More]
Using Parent Package Variables in Package Configurations (1)
Diane Guggisberg wrote: Sorry but I still cannot get this to work and ever... [More]
Creating packages in code - OLE-DB Source to Flat File File Destination (8)
S Desai wrote: Hello, I want to create packages in code - OLE-... [More]
SSAS Cache Warming Using SSIS (13)
Stephen wrote: WHere can i download the package you built? This i... [More]
Row Number Transformation (19)
Darren wrote: Ravi, I would add an Execute SQL Task before the D... [More]
Row Number Transformation (19)
Ravi wrote: HI I have a question? I have already 100 or... [More]
Downloading a file over HTTP the SSIS way (19)
Naresh Jagtiani wrote: Hello Darren, Thanks for your reply. This is wha... [More]
File Watcher Task (61)
Darren wrote: gaurav, can you double check you have downloaded a... [More]
Trace File Source Adapter (2)
Darren wrote: Michael, hands up, your right we don't observe Val... [More]
Downloading a file over HTTP the SSIS way (19)
Darren wrote: Naresh, This work fine with SSL. Your error in... [More]

Comment RSS

SQL Server Integration Services - SSIS

Sorting data in the SSIS Pipeline (Video)

Popular this month

SSIS Components

RecentComments

SQL Server Integration Services - SSIS

Sorting data in the SSIS Pipeline (Video)

Category list

Tags

Popular this month

SSIS Components

RecentComments