title: Error authenticating proxy user name or password is incorrect (SQL Server 2012, SSIS Package)
body: <p>Any help is appreciated. I have a SSIS package that pulls data from one location and dumps it to a .csv file at another location. The package executes beautifully from within Visual Studio. However, once I schedule the package to run via SQL Server Agent it fails with the following error:</p>
  
  <blockquote>
    <p>Error authenticating proxy <em>DOMAIN\UserName</em>, system error: The user name or password is incorrect.</p>
  </blockquote>
  
  <p>I'm running the SSIS execution as a proxy holding the credentials required where the .csv file is dumped. The user name and password are correct. The most interesting part is that I've mirrored these settings from a different server where the scheduled job runs without error.</p>
  
  <p>Do the credentials being used within the proxy somehow have to be tied into the SQL Server?</p>
  
  <p>Edit</p>
  
  <p>After changing "Run as:" from the proxy back to "SQL Server Agent Service Account", the error changes (as I expected it would) to this:</p>
  
  <blockquote>
    <p>Executed as user: NT AUTHORITY\LOCAL SERVICE... Cannot open the datafile <em>SERVER\Directory\file.csv</em></p>
  </blockquote>