Changing SSIS package property settings

After setting new SSIS package properties, you must recompile all objects. To quickly recompile pending objects, see the instructions in Recompiling All Pending Objects.

  1. From the DWD main menu, go to Administration > SSIS Property Settings.
  2. In the Source Objects & Properties section, select the objects you want to modify. To select multiple objects, hold the SHIFT or CTRL keys and select the objects.
  3. Specify new property values.
    SSIS Package (Extraction Task) Properties
    Isolation Level

    Specify one property:

    • Unspecified
    • Chaos
    • ReadUncommitted
    • ReadCommitted
    • RepeatableRead
    • Serializable
    Transaction Option

    Specify one property:

    • NotSupported
    • Supported
    • Required
    Package Level Property
    Protection Level

    Specify one property:

    • DontSaveSensitive
    • EncryptSensitiveWithUserKey
    • EncryptSensitiveWithPassword
    • EncryptAllWithUserKey
    • EncryptAllWithPassword
    • ServerStorage
    Note: Password and Confirm Password is applicable if Protection Level is set to EncryptSensitiveWithPassword or EncryptAllWithPassword .
    Fast Load Options
    No Locking on SQL Tables

    Click this option if you want to add a no lock option on the selected SQL data source tables.

    Note: 

    In the Modified Source Objects section, you can view the no lock option in the SQL Table no Lock column.

    Non-SQL data source tables will have a default value of No when selected.

    Max Insert Commit Size
    Specify the number of rows to commit in data insertion.
    Rows Per Batch
    Specify the number of rows in a batch.
    Data Flow Buffer
    Default Buffer Max Rows
    Specify the number of rows in a buffer.
    Default Buffer Size
    Specify the size of a buffer.
  4. Click the arrow to move the selected objects to the Modified Source Objects section.
  5. Click Apply > Yes to confirm the change.
  6. Click Close.