Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Data Warehousing » Integration Services » IsSort on Derived column transformation
Add to briefcase

IsSort on Derived column transformation Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
gracebite
Posted Wednesday, September 08, 2010 9:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:59 PM
Points: 16, Visits: 104
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
Raunak Jhawar
Posted Wednesday, September 08, 2010 10:08 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739
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
Justin James
Posted Tuesday, October 05, 2010 7:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:54 AM
Points: 49, Visits: 307
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
Raunak Jhawar
Posted Tuesday, October 05, 2010 7:24 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739
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
durga palepu
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 06, 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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.