title: SQL Server agent job failed. The package executed successfully
body: <p>Job runs from SQL Server 2008 64 bit</p>
  
  <p>Job step kicks off a SSIS package which runs successfully in BIDS. SSIS package copies data from an Oracle server to a database in SQL Server</p>
  
  <p>The login for the connection manager for the Oracle database is different than the login used to create the SQL Agent job. I doubt this is the issue because I have another job which does the exact same thing with same parameters as this job and SSIS package the only difference is the Job that works connects to a different Oracle database. </p>
  
  <p>The SSIS package is copying over the data nightly, record counts in source (Oracle) and destination (SQL Server) match but the error I get when I view the history is: </p>
  
  <blockquote>
    <p>X - The job failed. The Job was invoked by.....</p>
    
    <p>Selected row details:<br>
    Date      5/31/2013 12:00:00 AM<br>
    Log       Job History (DailyPull)</p>
    
    <p>Step ID       0<br>
    Server        SQL00<br>
    Job Name      DailyPull<br>
    Step Name     (Job outcome)<br>
    Duration      00:34:28<br>
    Sql Severity      0<br>
    Sql Message ID        0<br>
    Operator Emailed<br>
    Operator Net sent<br>
    Operator Paged<br>
    Retries Attempted     0  </p>
    
    <p>Message<br>
    The job failed. The Job was invoked by Schedule 20 (DailyPullSchedule). The last step to run was step 1 (DailyPull).</p>
  </blockquote>