Sent in by Trevor and the fine folks at NailSoup.

This is an enhanced version of the Sql Activity posted elsewhere on this site.

Issues fixed in this release are the following:

1. Ability to change the connection string in the CommandExecuting event.
2. Ability to handle a return value from the stored procedure.
3. Improved stability if the connection string is invalid at design time.

Issues I know of, but haven't had time to fix are:

1. The activity needs a hard-coded connection string at design time in order to understand stored procedure parameters.
2. If you change the parameters of a stored procedure at design time, the activity often "remembers" parameters that no longer exist. It is really hard to get rid of these without deleting the activity and starting again.
3. The activity doesn't handle output parameters. It thinks they are all input parameters.