Thanks - I looked at the data profiling task, but as far as I can see, it's not possible to put your own rules in.

For example, I want to log...

When you run it in Agent, it runs in the security context that Agent runs as. I found this led to problems connecting to other network resources - typically...

I've just battled through this - there's no way to parameterise loading tables in the way you suggest. In fact, I think SSIS makes it more difficult than it...