InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:40:19 GMT20http://www.sqlservercentral.com/Forums/Topic982776-364-1.aspxYou can sort the data in 2 ways1. sort the data in database and then apply the Issorted and sortkey position on the source adapter which comes before any transformation like derived column2. 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.Fri, 26 Aug 2011 11:11:03 GMTdurga palepuhttp://www.sqlservercentral.com/Forums/Topic982776-364-1.aspxEven better!!:-):-):-)Tue, 05 Oct 2010 07:24:36 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic982776-364-1.aspxYou 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.Tue, 05 Oct 2010 07:21:31 GMTJustin Jameshttp://www.sqlservercentral.com/Forums/Topic982776-364-1.aspx[quote][b]gracebite (9/8/2010)[/b][hr]Hi Friends, I am trying to enable IsSort property to True on Derived column transformationBut I couldn't[/quote]You may set the IsSort Property in the DFT itself and later pass the the set to derivied ColumnPS: 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 transformationWed, 08 Sep 2010 22:08:32 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic982776-364-1.aspxHi Friends, I am trying to enable IsSort property to True on Derived column transformationBut I couldn'tCan you please help me out, it is urgent for me Thanks in Advance GraceWed, 08 Sep 2010 21:53:48 GMTgracebite