the parm in the package is defined as a string, and a varchar() in the stored procedure... thanks

Thanks for the suggestion. I gave it a try and ended up with the following error message.

[Execute SQL Task] Error: Executing the query "exec RunCampaignRequest @Param1" failed with the following...