Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dmaxj
Posting Yak Master
174 Posts |
Posted - 2012-11-02 : 11:07:06
|
Hello, I am having an issue with getting an SSIS package to run from an SQL job. I am getting 'Login Failed' errors for my SQL login credentials when executing from a SQL job, BUT the package works when executing from Visual Studio and the Execution Package Utility.What could be preventing the job from running successfully?Regards |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-03 : 23:07:05
|
does the login that job uses have access to databases,folders,files etc that SSIS package is trying to connect------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|