Package variables are an important piece of component to create dynamic SSIS packages. There are two types of variables inside SSIS, system variables and user defined variables. System variables are not editable but can use as read only variables. The values of the system variables are set by the package for the purpose of tracking metadata such as Package ID. Effective use of system variables increases the performance of SSIS packages and using system variables is a good development practice as well. A list of system variables included in SSIS is mentioned bellow.
- System::ContainerStartTime
- System::CreationName
- System::LocaleID
- System::ParentContainerGUID
- System::TaskID
- System::TaskName
- System::TaskTransactionOption
- System::CancelEvent
- System::CreationDate
- System::CreatorComputerName
- System::CreatorName
- System::ExecutionInstanceGUID : Unique ID for each package execution.
- System::FailedConfigurations
- System::InteractiveMode
- System::LastModifiedProductVersion
- System::MachineName : Name of the computer
- System::OfflineMode
- System::PackageID : Unique Id generated for the package.
- System::PackageName : Name of the package.
- System::ProductVersion
- System::StartTime : Start time of the package.
- System::UserName : Package execution user
- System::VersionBuild
- System::VersionComments
- System::VersionGUID : Unique GUID for the package version
- System::VersionMajor
- System::VersionMinor
Two package execution instances of same package by diferent users on different machines is dipicted on the following figures. Notice that PackageID is an unique Id for the package while ExecutionInstanceGUID is unique for the package execution.
