System Variables of SQL Server 2005

Asked By molly diaz 0 points N/A Posted on - 11/30/2011

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?

• Status: Open
• Question Views: 1059
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Thompson Locker 10 points N/A #110757

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

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 01/03/2012
• Question Category: MS SQL Server