Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot run SSIS package from jobs

Status
Not open for further replies.

katbear

Programmer
Mar 14, 2007
270
US
Help. I am trying to run an SSIS package from Management Studio jobs. It probably has to do with passwords or something, but I am clueless where to fix. Thanks!

This is the error I am receiving:
Message
Executed as user: ABC\sqluser. ... Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:21:14 AM Error: 2007-03-15 11:21:14.73 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:property" 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: 2007-03-15 11:21:14.86 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" 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: 2007-03-15 11:21:22.18 Code: 0xC001602A Source: Oehm Automation - Fetch a... The package execution fa... The step failed.
 
try this thread from the SSIS forum.

thread1555-1328901

- Paul [batman]
- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top