SSIS Default Package Settings

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS Default Package Settings

SSIS Default Package Settings

Rate Topic

Display Mode

Topic Options

Author

Message

dwilliscp

Posted Monday, March 04, 2013 1:57 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:52 AM
Points: 187, Visits: 332

Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have to set it to ServerStorage everytime I create a package. Can not seem to find it in the Tools > Options and do not know where else to look.

Post #1426456

Phil Parkin

Posted Monday, March 04, 2013 2:06 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 4,238, Visits: 9,475

dwilliscp (3/4/2013)

Don't think you can. But you can create your own templates and use those instead when creating a package. See here for details.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1426459

« Prev Topic | Next Topic »

Permissions