You do not need to use ActiveX, by using an Execute SQL Task to DROP and CREATE the worksheet, if it is an existing Spreadsheet, it will keep the formatting. ...

One of the features they pulled from 2005 is the Auto Complete feature.  This is helpful for someone who is new to a DB/Table, as well as improves the ability...

Just a disappointed comment, was upset to hear the AutoComplete feature would not be availiable.  Had looked forward to that feature.

Also, on a...

I've worked with this several times, you will need to create your connecting to the Spreadsheet to use when creatingtables (worksheets) and transforming data.

Create an Execute SQL Task, with the CREATE TABLE...