I already have an SSIS package that runs perfectly that I just built with the export wizard in SQL. However, I want the Excel sheet output to have a certain formatting. I want to headings shaded and the output range in gridlines. How is it possible to make the package do this? I have Microsoft Visual Studio to edit the package, I just have never used it. Thanks, Alex K

You then need to use MS Office interoperability. Specifically you will add some .Net code into a new component namely the Script Task.Arthur My Blog

To compliment my reply above: Here is a short demonstration on how to format an Excel spreadsheet using C# (if you are on SSIS 2008): http://csharp.net-informations.com/excel/csharp-format-excel.htm Just create your own code and use it inside the Script Task.Arthur My Blog