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 |
|
berengar
Starting Member
21 Posts |
 Posted - 2008-09-18 : 04:31:28
|
| Hi I have an SSIS package that runs ok when executed through BIDSbut fails when run through MS SQL 2005 "Enterprise manager" or the equivalent. The package retrieves document paths from a db, and copies said documents to the local (db) server.The db Server DOES have access to the remote server (where it gets the docs from) The SSIS pack fails on a schedule or run through SQL 2005 with the message "no access to "path" .. im thinking it's because the sa user hasn't access to this server.maybe sa needs domain access .. how can i grant different levels of access to sql users? |
|
|
|
|
|
Job Failing