SQL job running SSIS package failing on security

  • I got this error in the job history when I tried to run it. I have it running under a service account with tons of rights. I've looked at previous posts but to no avail so far. The package runs fine, also runs fine as a manifest, just not as a job.

    Can someone help explain what is going on below?

    TIA

    Andre

    Message

    Executed as user: FIBxxxx\SYSTEM. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:28:47 PM Error: 2009-03-02 14:28:48.06 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 available. End Error Error: 2009-03-02 14:28:48.76 Code: 0xC001401E Source: PcsImport Connection manager "ADDRDDA txt" Description: The file name "\\xxxx\data\!Daily\ADDRDDA.txt" specified in the connection was not valid. End Error Error: 2009-03-02 14:28:48.76 Code: 0xC001401D Source: KidsSaveFirstPcsImport Description: Connection "ADDRDDA txt" failed validation. End Error Error: 2009-03-0... The package execution fa... The step failed.

  • This most likely has to do with the Package ProtectionLevel. The default is EncryptSensitiveWithUserKey which means only the user who saved the package can open it or execute it. See this KB article: http://support.microsoft.com/kb/918760.

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply