May 21, 2010 at 3:00 am
I have a serious problem, that is almost killing me.
I have a simple package. I have tried to store it in SQL Server and in filesystem and I can run it manually with DTEXEC from commandpromt, I can run it from Visual studio.
All work like a charm and everything is very good, BUT!!!! When i try to run it from SQL Server Agent, then it start and hangs. It just says Running.
When I open Integration Services, then the packages is not running.
I have tried debugging, logging and all what I know, but nothing helps.
Any good ideas?
Søren
Søren,
MCITP SQL 2008 (administration / programming), MCITP SQL 2005 (BI), MCT
May 25, 2010 at 5:32 am
What is the purpose of the package? What tasks/data flows/components are present in the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 30, 2010 at 9:53 am
When you run it in Agent, it runs in the security context that Agent runs as. I found this led to problems connecting to other network resources - typically the account has lots of rights on the machine, but none on the network
You can specify that the job runs as someone else, which I suspect should help
Do you get anything in the job history?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply