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.
| Author |
Topic |
|
dirs
Starting Member
14 Posts |
 Posted - 2010-07-22 : 04:38:57
|
| I am trying to run SSIS package as a scheduled job. WHen I run the job I get error msg 'the job failed. The job was invoked by user sa'.When I created the package it executed normally without any error msgs. WHy I am gettting errors when I run it as a job? Thanks and Regards :) |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-22 : 05:02:30
|
right click jobview historysee error message in detail at the job steppost it here
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
dirs
Starting Member
14 Posts |
Posted - 2010-07-23 : 03:19:06
|
| Here is the error msg:The job failed. The Job was invoked by User sa. The last step to run was step 1 (test).,00:00:17,0,0,,,,007/22/2010 10:36:34,test,Error,1,database,test,test,,Executed as user: database\SYSTEM. ... 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:36:34 Error: 2010-07-22 10:36:34.40 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is availableWhen I created the package I used package protection level 'Encrypt sensitive data with user key'. Is it because of that? Which protection level is recommended? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-23 : 03:22:15
|
I am using ALL WITH PASSWORD
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
dirs
Starting Member
14 Posts |
Posted - 2010-07-23 : 03:29:13
|
| Hi again, I tried to execute the same package with dtexecui.exe command but got some errors this time : Error: Executing the query " create table 'test'( parameters) failed with the following error: " Table 'test' already exists" Possible failure reason: problem with the query, " Resultset property not set correctly or connection not established correctly.Thanks for the help! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-23 : 12:29:26
|
| you need to test for the existence of tables before trying to create or drop them in your packages (or any other scripts).IF Object_ID('test') IS NULL Create Table test (...)as for the authentication errors, I always use "Rely on Server Storage and Roles" |
|
|
|
|
|
|
|
|
SQl job failure