August 25, 2012 at 10:47 pm
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
August 26, 2012 at 4:39 am
SSIS homework?
Odd request, if I want the rows sorted, they have to be sorted somewhere...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 27, 2012 at 7:18 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply