DTS to Excel ... Need Excel to have a default sort

[JayKusch]

Have a package that runs a complex SQL Server Stored Procedure. The results are exported out to an Excel worksheet that is dropped and recreated each time the package is executed.

I know I can rework the stored procedure to output the resulting record set in the order I need BUT is it possible when you are creating the Excel worksheet within the DTS package to define a column as a default sort field?

Thus after the export to Excel, I am able to open the worksheet and the data will be sorted already by the defined field in the package?

Thanks

J. Kusch