how to avoid sort transformations

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » how to avoid sort transformations

how to avoid sort transformations

Rate Topic

Display Mode

Topic Options

Author

Message

SS53217

Posted Saturday, August 25, 2012 10:47 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, September 07, 2012 4:54 PM
Points: 11, Visits: 23

Can anyone tell me :- "How to export Records from a table of a database to an excel file sorted based on First Name(column name) without using SORT transformation

Post #1350090

GilaMonster

Posted Sunday, August 26, 2012 4:39 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

SSIS homework?

Odd request, if I want the rows sorted, they have to be sorted somewhere...

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1350102

vinod.andani-874416

Posted Monday, August 27, 2012 7:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, September 07, 2012 5:25 AM
Points: 231, Visits: 61

Sort the records from a table using ORDER BY in OLE DB Source component before sending rows to excel spreadsheet

e.g., SELECT cols......
FROM your_table_name
ORDER BY column_name you want to order

Above statetment should be in OLE DB Source in a Data Flow Task

Post #1350371

« Prev Topic | Next Topic »

Permissions