Post reply

SSIS Job fails after One time Execution

  • June 27, 2007 at 10:25 am

    #179589

    Hi,

    I have one SSIS package that has proxyaccount as owner, It is sch.  to run once every day as job with same proxyaccount as job owner.

    First time when I Save package and Import to MSDB  and job will run successfully.

    Next day again job will fail. Again I go back to package and place pw to DB connection save and import package and job will succeed.

    Job history shows this error

    Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTSassword" with error 0x80070002 "The system cannot find the file specified.". 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. Description: "Login failed for user 'abc_data'."

    Any thought or suggestion will be a great help.

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • June 28, 2007 at 2:02 am

    #715749

    I love the way error messages have portions converted to smilies...

    It is your package protection level.

    As to why it runs once and then not again, I cannot say.

    See http://technet.microsoft.com/en-us/library/ms141747.aspx

    A way I use is to set it to don't save sensitive and try not to use any passwords. Obviously this is not always possible. In that case, use XML configuration to set the password at run time. This file, .dtsconfig, can be locked down in a directory which only has read and write rights to the service account.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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