February 7, 2014 at 2:31 pm
Hi,
I created a SSIS package
My SSIS package is running fine in the BIDS but when I created job through SQL Agent it is failing. Please let me know the possible reason
February 7, 2014 at 2:40 pm
Probably security. What's the error in the Job history/step log?
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
February 7, 2014 at 2:41 pm
When that happens to me, its usually permissions. The job is typically run by the sql agent account which may not have access to something referenced in the package, like a network drive for instance.
February 8, 2014 at 5:49 am
Thank you.
Yes, when I changed the SQL Agent account to local system it is working fine for me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply