how to ''create new/overwrite existing'' worksheets in xls output?

anyone know how you can do this?

Yes, If I'm not wrong you can use Execute Sql Task in order to create a new one using Excel Connection Manager:

Example:

CREATE TABLE `Z` (
`CODIGO_TERRITORIAL` Byte ,
`CODIGO_REGIONAL` Byte)

|||

Enric is right, you can create the sheet via execute sql task. In order to override it, the easiest way I know is to delete/move the file so the next time the file gets create again. There are lot of threads that tlaks about that.

I have an example that can help you:

http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html