Scheduling SSIS Packages - SQL School Video

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Scheduling SSIS Packages - SQL School Video

Scheduling SSIS Packages - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Thursday, October 09, 2008 1:06 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the item Scheduling SSIS Packages - SQL School Video

Brian Knight
Free SQL Server Training Webinars

Post #583090

Anipaul

Posted Thursday, October 09, 2008 1:45 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336

Nice :):)

Post #583105

moguel

Posted Thursday, October 09, 2008 8:57 AM

Forum 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

Brian Knight

Posted Thursday, October 09, 2008 9:52 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

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

moguel

Posted Friday, October 10, 2008 10:25 AM

Forum 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

Tara-1044200

Posted Friday, August 14, 2009 7:52 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:37 PM
Points: 983, Visits: 2,924

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

adam.plager

Posted Tuesday, January 19, 2010 9:47 AM

Forum 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

pranethpalla

Posted Tuesday, December 14, 2010 7:42 AM

Forum 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

Alan Richmond

Posted Wednesday, January 04, 2012 3:56 PM

Forum 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 »

Permissions