August 14, 2013 at 9:04 am
I've created a package to import an excel file into a SQL table then run a SP.
The idea is then to make this very easily runnable - the file is updated each day and someone else will be doing the import and update. So I'd like to create a job to run the package, there is already a credential using the sqlservice identity so I could set up a proxy account using that to run the job.
BUT - the file will be in a folder on one domain server whereas the SQL server instance where the job / package will run is on a different domain. I'm thinking that what I need to do is share the folder with the file in it with the proxy account / credential - does that sound right and how do I do it? When I attempt the share it will only find the accounts within its own network?
August 14, 2013 at 9:33 am
You can setup a trust between the two domains. That will allow each one to see the other's logins.
August 14, 2013 at 10:05 am
One of them is a hosted / cloud domain and I don't think we have that degree of 'trust' between the two - generally they need to be separate. So if there's a way to just share specific data in a very controlled way that would be preferable
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply