Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scheduling SSIS Packages - SQL School Video Expand / Collapse
Author
Message
Posted Thursday, October 9, 2008 1:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
Comments posted to this topic are about the item Scheduling SSIS Packages - SQL School Video

Brian Knight
Free SQL Server Training Webinars
Post #583090
Posted Thursday, October 9, 2008 1:45 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:47 AM
Points: 5,449, Visits: 1,401
Nice :):)


Post #583105
Posted Thursday, October 9, 2008 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 1, 2011 1:34 PM
Points: 3, Visits: 77
I got this message, does someone face this kinf of issue, I think I need more permission.

Message
Executed as user: ServerName\SYSTEM. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:54:31 AM Error: 2008-10-09 09:54:32.55 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: 2008-10-09 09:54:35.28 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: 2008-10-09 09:54:35.28 Code: 0xC0016016 Source: Description: Failed ... The package execution fa... The step failed.
Post #583387
Posted Thursday, October 9, 2008 9:52 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
This is a common problem where the job doesn't have the rights to run the package. The default property for a package is EncryptSensitivewithUserKey for the ProtectionLevel property. Ideally, you should set that to EncryptAllwithPassword and pass the password into the package.

Brian Knight
Free SQL Server Training Webinars
Post #583434
Posted Friday, October 10, 2008 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 1, 2011 1:34 PM
Points: 3, Visits: 77
Thanks for your soon answer Brian, I will do it and if I got an error I will let you know.

Regards,
Miguel
Post #584109
Posted Friday, August 14, 2009 7:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:24 AM
Points: 1,000, Visits: 2,979
I got the same error and tried different options for protectionlevel but failed with same error.

i tried serverproperty and dont save sensitive but still failed.
Post #771394
Posted Tuesday, January 19, 2010 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 4, 2011 7:39 AM
Points: 1, Visits: 41
That resolved it for me but it really doesn't make sense why it works. Any clues? All I know is it's resolved and I'm ahppy
Post #849876
Posted Tuesday, December 14, 2010 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 13, 2011 9:33 AM
Points: 1, Visits: 9
Thanks Brain that really helped.
Post #1034420
Posted Wednesday, January 4, 2012 3:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 4, 2012 3:56 PM
Points: 1, Visits: 2
thanks Brian, worked like a charm
Post #1230420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse