Hands-On Microsoft SQL Server 2008 Integration Services part 12. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 88 Hands-On Microsoft SQL Server 2008 Integration Services System Variable Assigned to Description CancelEvent Package When set to a nonzero value the task stops running CreationDate Package Date when the package was created CreatorName Package Name of the person who built this package MachineName Package Name of the computer on which the package runs PackageID Package Unique identifier of the package PackageName Package Name of the package StartTime Package Time that the package started to run UserName Package Account of the user who started the package VersionBuild Package Package version VersionComment Package Comments about the package version TaskID Tasks Unique identifier of a task instance TaskName Tasks Name of the task instance TaskTransactionOption Tasks Transaction option the task uses ErrorCode Event handlers Error identifier ErrorDescription Event handlers Description of the error PercentComplete Event handlers Percentage of completed work SourceDescription Event handlers Description of the executable in the event handler that raised the event SourceID Event handlers Unique identifier of the executable in the event handler that raised the event SourceName Event handlers Name of the executable in the event handler that raised the event VariableDescription Event handlers Variable description VariableID Event handlers Unique identifier of the variable Table 3-1 Partial List of System Variables Available in Various Containers Method You will create a simple package consisting of one task to demonstrate how you can use system variables to create a custom log which is desirable if standard logging doesn t meet your purposes. You will create a table in the Campaign database to host logging information and will then use the Execute SQL task to read values of system variables for logging to the earlier created table. You will also add a connection manager to connect to the Campaign database. Chapter 3 Nuts and Bolts of the SSIS Workflow 89 Exercise Adding a .
