System Variables of SQL Server 2005

When you have to use the system variables in SQL server you will need to use the SQL Server 2005 Integration Services (SSIS). The  SSIS service is now drastically improved over the DTS in the SQL Server 2000 so that it can be able to provide a much better support for the use of variables.

 

To understand how to make good use of the system variables inside your SSIS applications, here is an example that will guide you, which uses SSIS system variables to create a simple package auditing, so as to keep track of the successes, failures, and potential performance degradation over time.

 

CREATE TABLE PackageSystemAudit

 

PackageAuditID INT IDENTITY(1,1) PRIMARY KEY,

 

PackageName VARCHAR(255),

 

CreationName VARCHAR(255),

 

MajorVersion INT,

 

MinorVersion INT,

 

VersionGUID UNIQUEIDENTIFIER,

 

MachineName VARCHAR(255),

 

CreationDate DATETIME,

 

StartDate DATETIME DEFAULT(GETDATE()),

 

EndDate DATETIME,

 

PackageID UNIQUEIDENTIFIER

 

Thompson Locker