My SSIS package uses a connection string populated by a user defined variable.
I want to put an event handler on the connection manager to execute a task when there is an error with the connection string.
I have tried placing my task in the OnError Event Handler.
Here is the problem...........I have testing it with a bad connection string but the error seems to be generated before the OnError has a chance to capture the problem.
Can anybody help?