f70b2ffb   
   From: esquel@sommarskog.se   
      
   js (androidsun@gmail.com) writes:   
   > I created a SSIS package that contains 6 Execute SQL Tasks and 1   
   > Analysis Services Processing Task.  I creted a nightly job that   
   > contains only 1 step which is to execute the package.  The job always   
   > runs successfully with the following message.  However, noe of the   
   > tasks inside the job step is executed.   
   >   
   > The job succeeded.  The Job was invoked by Schedule 101 (Project Daily   
   > Updates).  The last step to run was step 1 (Project Daily Updates   
   > Step).   
   >   
   > When I execute the job step each morning, the tasks are then executed   
   > successfully.  I set the package ProtectionLevel property to   
   > EncryptSensitiveWithUserKey and entered a key in PackagePassword   
   > property.  When using Importing Package into the SSIS storage, I also   
   > sect Protection Level to "Encrypt sensitive data with user key".   
   >   
   > Does anyone know why such a false success?   
      
   Check under Advanced. You might have select "Quit the job reporting   
   success". You can also check the job step details in the job history,   
   to see if there is any output.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)