Though SSIS are a really powerful tool i find some very ugly behaviour,
which really make difficoult to me use SSIS in enterprise solutions.
The problem i'm facing now is logging. Logging has been published (even
by me in all Italian Sql Server 2005 Events) as a GREAT functionality
but it really has some seriuos limitations.

The biggest one probably is that is not possibile to configure
dynamically the SQL Connection used to log to the sysdtslog90 table. In
fact if i try to use expressions to define the "Inital Catalog"
property, and i bind the variable used by expression to a package
configuration, the validation, which seems to happen BEFORE
configurations are loaded, will fail the package saying the, for
example, the target database does not exists.

Any help or suggestions?

thanks in advance!

Davide