Hi,

I need to create a very flexible package. It is used for exporting reports
to excel from SQL server 2005, and I don't know in advance what column names
the report will contain. Thus, if I have an OLE DB source I need to set the
SQL dynamically (I think I can do this by letting it use SQL from a
variable.). I also need to set some properties on the Excel destination at
runtime, so that the Excel destination properties can be set at runtime. I
wondered if I could use the script task to handle this, but there seems to be
no way of getting hold of the Excel destination object from there (data
access - sql, name of excel sheet, mappings etc.). And there seems to be no
way to set these properties to be read from a variable.

How can I set these properties at runtime? Will I have to create the a whole
new package programmatically? And will I be able to do this from the script
task?

I have searched for documentation on this, but I think Microsofts examples
are limited, so I anyone has any links or advices I would appreciate it very
much.

Thanks,
Dorte