title: Executing an SSIS package from SQL job
body: <p>I have created an SSIS package that simply replicates 1 table to another (on 2 different servers). When I run the SSIS package from the designer, it works perfectly.</p>
  <p>However, when I create an SQL Job as it needs to be run automatically.  but it fails with a permissions issue.</p>
  <p><a href="https://i.stack.imgur.com/39njE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/39njE.png" alt="enter image description here" /></a></p>
  <p>I am logged onto the to the server with an administrator user.</p>
  <p>I have googled this and have tried a host of different things,  encrypting the password etc and trying to execute with a proxy user but nothing seems to work.</p>
  <p>I would like to know what this user refers to here:</p>
  <p><a href="https://i.stack.imgur.com/JKYrE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JKYrE.png" alt="enter image description here" /></a></p>
  <p>Its the domain name and server name, but I have no idea where this user exists or even if it is an legit user?</p>