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, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
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: 2 days ago @ 8:00 AM
Points: 49, Visits: 316
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, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse