Do you have the step logging on? That truncated version (which you got from the history window) doesn't have the full story.
You need to open the step log and look in there. The error you're looking for will be inside that. My guess? Security. The Job runs the package as the agent, the package runs as you when you trigger it.
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