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 09, 2008 1:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, August 19, 2013 12:07 PM
Points: 1,929, Visits: 228
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 09, 2008 1:45 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,191, Visits: 1,368
Nice :):)


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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 01, 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 09, 2008 9:52 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, August 19, 2013 12:07 PM
Points: 1,929, Visits: 228
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 01, 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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, January 09, 2014 7:44 AM
Points: 988, Visits: 2,945
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 04, 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 04, 2012 3:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 04, 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