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?

js (android... at (no spam) gmail.com) writes:
I created a SSIS package that contains 6 Execute SQL Tasks and 1
Analysis Services Processing Task.  I creted a nightlyjobthat
contains only 1 step which is to execute the package.  Thejobalways
runs successfully with the following message.  However, noe of the
tasks inside thejobstep is executed.

Thejobsucceeded.  TheJobwas invoked by Schedule 101 (Project Daily
Updates).  The last step to run was step 1 (Project Daily Updates
Step).

When I execute thejobstep 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 afalsesuccess?

Check under Advanced. You might have select "Quit thejobreportingsuccess".. You can also check thejobstep details in thejobhistory,
to see if there is any output.

--
Erland Sommarskog, SQL Server MVP, esq... at (no spam) 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- Hide quoted text -

- Show quoted text -

Thanks for the response. I tried to change the job step's "On success
action" to "Go to the next step" but the SQL Server does not allow it
because there is only one step.

The following is output of the exact job step details in the job
history:
The job succeeded. TheJobwas invoked by Schedule 101 (Project Daily
Updates). The last step to run was step 1 (Project Daily
UpdatesStep).