Funcionality Request

I have a functionality request for the SSIS team.

I have come across a situation where a flat file was sorted by one column but I would like to add a secondary sort to the data pipe.  I think it would be great if the sort task was clever enough to just add an additional sort column instead of having to wait to buffer the entire pipe until releasing any data downstream.

If we know that there is already one sort column on the data pipe, the sort task should be able to release data down the pipe as soon as all of that particular member of the primary sort was in the sort task buffer.

Advertisements

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: