Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

IsSort on Derived column transformation Expand / Collapse
Author
Message
Posted Wednesday, September 8, 2010 9:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 11:07 AM
Points: 25, Visits: 152
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
Post #982776
Posted Wednesday, September 8, 2010 10:08 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 1, 2015 12:31 AM
Points: 1,048, Visits: 1,869
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


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #982782
Posted Tuesday, October 5, 2010 7:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 5, 2015 11:30 AM
Points: 49, Visits: 326
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.
Post #998328
Posted Tuesday, October 5, 2010 7:24 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 1, 2015 12:31 AM
Points: 1,048, Visits: 1,869
Even better!!

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #998332
Posted Friday, August 26, 2011 11:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 10:10 AM
Points: 57, Visits: 46

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.
Post #1166291
Posted Monday, February 2, 2015 8:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 3, 2015 2:45 AM
Points: 30, Visits: 53
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!
Post #1656810
Posted Monday, February 2, 2015 8:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:11 AM
Points: 2,266, Visits: 1,619
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
Post #1656819
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse