SSIS System Variables

The SSIS System variables stores and helps to provide the information about the running Package and the log information. This SSIS Integration Services article shows how to use the System variables with an example.

The following list shows the list of available system variables in SSIS.

System VariableData TypeDescription
CancleEventInt32The task stops running.
ContainerStartTimeDataTimeThe Container Start Time.
CreationDateDataTimeThe Package created date.
CreatorComputerNameStringThe name of the computer on which this package was created.
CreatorNameStringThe username who created this package.
ExecutionInstanceGUIDStringA Unique Execution Instance ID of a Package.
FailedConfigurationsStringThe name of the package Failed configurations.
IgnoreConfigurationsOnLoadBooleanTo ignore the package configurations while loading the package or not.
InteractiveModeBooleanTo run the Package in Interactive Mode or not.
LocaleIdInt32The Locale that the package uses.
MachineNameStringComputer name which the package runs.
OfflineModeBooleanWhether the package is in Offline Mode.
PackageIDStringA unique package ID.
PackageNameStringName of a Package.
StartTimeDateTimePackage start Time.
ServerExecutionIDInt64Package Execution ID on Integration Services Server.
UserNameStringThe User who started the package.
VersionBuildInt32Package Version.
VersionCommentStringPackage Version comments.
VersionGUIDStringA unique ID of a version.
VersionMajorInt32Package Major Version.
VersionMinorInt32Package Minor Version.

SSIS System Variables Example

Drag and drop the SSIS Data Flow Task into the control flow region.

Data Flow Task

Double-click to open the Data Flow Region. Then, add the flat file source and double-click on it to open the Source Editor. 

Click the New button to open the Flat File Connection Manager Editor window. Next, click the Browse button to choose the Employee file. 

Flat File Source

If the file’s first row has header names, checkmark the Column Names in the first data row option.

Use the advanced section to change the Data type. Here, the column data type must match the destination table; otherwise, it throws an error. After you finish, click OK to close the window.

Set the Data Types of Input Columns

Drag the Derived Column Transformation and connect it to Flat File Source. Double-click on it to open the editor.

Derived Column Transformation Editor for SSIS System Variables

We are using some system variables in this SSIS example, but you can try the remaining ones.

SSIS System Variables 5

Next, drag the OLE DB Destination and double-click on it to open the Editor. Then, we have chosen the existing connection. Next, click the New button to create a new table.

OLEDB Destination

Go to the Mappings tab to check the input and available destination column mapping.

check the input and available destination column mapping

Run the SSIS System Variables package.

Run the SSIS System Variables package

You can see the machine Name, Start Time, etc., within the SQL Management Studio.

SSIS System Variables Result

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.