N/APosted 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?
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,
StartDate DATETIME DEFAULT(GETDATE()),