Then your object is configured wrong, or your exec statements are coughing up errors. Things to check offhand:
It doesn't appear that you're using parameters, so make sure there's nothing in there.
Confirm your connection is setup properly, and is correctly set on the Execute SQL object.
Swap Bypass Prepare to TRUE. Usually only necessary for parameterized stuff.
See if you can run a simple SELECT 1 FROM sysobjects from the Task.
You need to nail down if it's the EXEC call, or the object, causing the issue.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA