March 15, 2011 at 4:38 pm
Hello everyone,
I have an IS package that runs perfectly inside of the BI Development Studio (SS2008R2 w\BIDevStudio2008) but when I set up an Agent job to run the package at an interval it fails. The package uses 3 connection managers to SQL instances that are within the Domain. Again, the package runs perfectly in the Dev Studio.
Any ideas would be greatly appreciated.
Thanks.
March 15, 2011 at 4:45 pm
What's the error in the job history?
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
March 17, 2011 at 4:47 am
Does the SQL Server Agent user account have all the necessary permissions to connect to the instances and perform the tasks you implemented in the SSIS package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply