Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  ssis scheduling

Author  Topic  sek Starting Member 27 Posts Posted - 2009-09-30 : 23:17:32 Hi All, I am deployed my ssis package in the sql server 2005.I kept protection level as "EncryptSensitiveWithUserKey" in my package. when i scheduled my job its failing.i am getting the following error messages. step name(Job Outcome) The job failed. The Job was invoked by Schedule 2 (ssis sch1). The last step to run was step 1 (step1). step name(step1) Executed as user: BP242\SYSTEM. The package execution failed. The step failed. how to resolve this issue? I just kept a messagebox in my package. one more thing i observed that while defining job we need to select log on to server. i.e either Use windows Authentication or Sql Server Authentication I am selected Sql Server Authentication while defining the job.while editing the same job its showing windows Authentication.whats the reason?do we need to set any property anywhere else??? thanks in advance.