IsSort on Derived column transformation

Question

IsSort on Derived column transformation

gracebite

Right there with Babe

Points: 725
More actions
September 8, 2010 at 9:53 pm

#144965

Hi Friends,
I am trying to enable IsSort property to True on Derived column transformation
But I couldn't
Can you please help me out, it is urgent for me
Thanks in Advance
Grace

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

gracebite (9/8/2010)
Hi Friends,
I am trying to enable IsSort property to True on Derived column transformation
But I couldn't

You may set the IsSort Property in the DFT itself and later pass the the set to derivied Column

PS: IsSort will not sort your dataset...it will rather tell the Derived column task that the dataset is sorted already..

Incase you wish to sort the data you will have to implement the Sort transformation

Raunak J

jjbear11 Default port Points: 1497 More actions · Answer 2

You could also sort your data at the extraction point. That is substantially faster than the sort transform, since the heavy lifting is done on the SQL server side and not in memory via Visual Studio.

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 3

Raunak Jhawar

SSCoach

Points: 15701

October 5, 2010 at 7:24 am

#1231679

Even better!!:-):-):-)

Raunak J

durga palepu Say Hey Kid Points: 701 More actions · Answer 4

You can sort the data in 2 ways

1. sort the data in database and then apply the Issorted and sortkey position on the source adapter which comes before any transformation like derived column

2. If its not possible in DB end, then use SORT transformation in SSIS which is asynchronous and blocking in nature.

Hope this helps you:-)

Durga.

Rich Parsons SSC Veteran Points: 237 More actions · Answer 5

This was helpful, so thanks.

I needed to use a Derived Column transform, then a Sort, and undo the IsSorted and SortKeyPosition, before the Merge Join would work. I'm still annoyed, however, that I needed to trim the nvarchars in the first place, in order to get a match!

Lempster SSCoach Points: 15651 More actions · Answer 6

Rich Parsons (2/2/2015)
This was helpful, so thanks.
I needed to use a Derived Column transform, then a Sort, and undo the IsSorted and SortKeyPosition, before the Merge Join would work. I'm still annoyed, however, that I needed to trim the nvarchars in the first place, in order to get a match!

So, are you sorting on the Derived column then? If not then why can't you do the sort using an ORDER by in the source query - much faster as an earlier poster has already said?

Regards

Lempster