title: SSIS file started by SQL Server Agent fails (Source SQLISPackage120, Event ID: 12291)
body: <p>I have SSIS file *.dtx which works on test machine with test sql server and works locally started with production/test sql server. When the file is moved to production machine and started with production machine (no change of credection in SSIS file) it fails with message in event log: <code>Source SQLISPackage120, Event ID: 12291</code>.</p>
  
  <p>The logging is turned on: with works everywhere except production machine. It logs also when SSIS file is started locally from VS but with production database.</p>
  
  <p>How to find more information about problem?</p>
  
  <p>UPDATE1:</p>
  
  <p>I found in SQL Agent log file entry:</p>
  
  <p>Login failed for user 'aaa'. Reason: Password did not match that for the login provided. [CLIENT: ...]</p>
  
  <p>How to configure windows user to be able to run SSIS task (or to be able to log in SQL server from SSIS)?</p>