Professional SQL Server™ 2005 Integration Services

3.1. Shared Properties

No matter what task you use in your package, there is a standard set of properties for each task in the SSIS environment that you will have available to you. Many of the same properties have been carried over from SQL Server 2000 DTS, but most are new and complete the vision of an enterprise-ready ETL tool. Here is a list of the properties that you will use:

• Disable: If set to true, then the task is disabled and will not execute.

• DelayValidation: If set to true, SSIS will not validate any of the properties set in the task until runtime. This is useful if you are operating in a disconnected mode and you want to enter a value for production that cannot be validated until the package is deployed. The default value for this property is false.

• Description: The description of what the instance of the task does. The default name for this is <task name>, or if you have multiple tasks of the same type, it would read <task name 1> (where the number 1 increments). This property does not have to be unique and should accurately describe what the task does for people who may be monitoring the package in your operations group.

• ExecValueVariable: Contains the name of the custom variable that will store the output of the task's execution. The default value of this property is <none>, which means that the execution output is not stored.

• FailPackageonFailure: If set to true, the entire package will fail if the individual task fails. By default, this property is set to false.