I have a question.. our client needs to export data from SQL Server 2000 to Excel.. but the Excel sheet should have multiple tabs (which is simply done of course) and a fairly nice looking format to it. The Excel file they have in mind has columns like Item Number, Description, Quantity, Total, Grand Total, etc.

I'd hate to have to dump all these columns and formatting (and possibly formulas) via code in DTS. Is there some way I can create a "template" Excel file that already has all the headers and misc. text, and then just fill in certain cells via DTS? Is that possible?

Also, how do I set a formula in a cell using DTS?

This is pretty advanced for me.. I don't know too much about DTS other than the very basics, so bear with me.