title: How to deploy ETL package to a remote SQL Server with SQL authentication?
body: <p>I'm new to ETL so I have developed a simple ETL package, and now I'm going to deploy it to a remote server.</p>
  
  <p>I connect to server using SQL Server authentication, so I go to solution explorer and open deployment wizard, in there in destination tab entered my server ip and then it shows me a error message saying </p>
  
  <blockquote>
    <p>Login failed for user 'MYDOMAIN\MYUSERNAME'. (.Net SqlClient Data Provider)</p>
  </blockquote>
  
  <p>As I said earlier I want to use SQL Server authentication to connect to my server, where can I change this settings in SSIS ?</p>