September 4, 2008 at 5:12 pm
We created an SSIS package (in BIDS) that reads a source file on a different server. When run interactively, the package can access the file through a network share but we want to run it non-interactively. In that case, we can't use "Windows authentication" (there is no interactive user) and we certainly can't use sql authentication. How can SSIS be used to read that remote file?
TIA,
Barkingdog
September 4, 2008 at 5:54 pm
I think it depends how you are running the ssis package. If you are running it via a proc or job then I believe it will run under the sql service account. That account in our environment is a domain account so it would work here.
September 5, 2008 at 4:23 am
You have to make network share accessible for user that runs SSIS package. If it's not domain account I believe workaround would be to set permissions for everyone.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply