System Variables of SQL Server 2005

Asked By 0 points N/A Posted on -
qa-featured

How can I view System Variables in the dropdown menu of SQL Server 2005 running on a Windows XP computer? Can anyone please help me?

SHARE
Answered By 0 points N/A #110757

System Variables of SQL Server 2005

qa-featured
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

Login/Register to Answer

Related Questions