sql server business intelligence development studio demo

The other options are Required and NotSupported. called from another package) it will enlist or join the transaction which certainly makes sense as a default. If a package is executed within an existing transaction (i.e. The default value of Supported is probably a good one. The TransactionOption allows you to choose how the package behaves with respect to database transactions. The Serializable level generally results in additional locking and decreased concurrency so you should consider whether you really need this and choose one of the other levels such as ReadCommitted.

Surely there are times when this transaction isolation level is warranted but certainly not always. In addition range locks are held so that no data can be inserted such that rerunning any query in the transaction would return the rows added which weren't there at the beginning of the transaction. Serializable is the level where read locks are held until a transaction commits or rolls back which provides that no data read can be updated. Note that the default value is Serializable which may not be what you really need. The IsolationLevel property is setting the Transaction Isolation Level. A good way around this is to change the ProtectionLevel to DontSaveSensitive, meaning you aren't going to put sensitive information in the package so there's no need to worry about encryption. When another user executes the package it will fail because that user's key will not be able to decrypt the connection string. The default setting will encrypt this information using the user key of the person who created the package. An example of sensitive information is a database connection string that contains a password in it.

I point this one out because the default value of EncryptSensitiveWithUserKey will often cause problems. The ProtectionLevel provides for various options for encrypting the package and/or portions of the package. I collapsed the property groups and left expanded the few that we will discuss here:

Sql server business intelligence development studio demo