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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-09-11 : 12:30:46
|
| How to run from sql server A a package that exists on sql server Bwhere A and B are not in the same domain and can not see each other they are set this way for security reasons. I.e some ports are closedIf I save the package as a file system package will that work and if so is there anything special I should do other then allowing proxy to have sql command line access.and should the sql server agent on both machines have the same name and same passwordThankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-11 : 13:02:06
|
| you can save the package in a folder in serverB and make folder as file system. then in server A add a job to call this package from serverb giving UNC path \\serverB\... and give access to the folder for the proxy account you created in server A so that it can access the package and then in job configure to use that proxy account------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-11 : 13:33:58
|
| Thanks a lotsarah |
|
|
|
|
|
|
Run a package on another sql server