- System::ContainerStartTime
- System::CreationName
- System::LocaleID
- System::ParentContainerGUID
- System::TaskID
- System::TaskName
- System::TaskTransactionOption
- System::CancelEvent
- System::CreationDate
- System::CreatorComputerName
- System::CreatorName
- System::ExecutionInstanceGUID : Unique ID for each package execution.
- System::FailedConfigurations
- System::InteractiveMode
- System::LastModifiedProductVersion
- System::MachineName : Name of the computer
- System::OfflineMode
- System::PackageID : Unique Id generated for the package.
- System::PackageName : Name of the package.
- System::ProductVersion
- System::StartTime : Start time of the package.
- System::UserName : Package execution user
- System::VersionBuild
- System::VersionComments
- System::VersionGUID : Unique GUID for the package version
- System::VersionMajor
- System::VersionMinor
Friday, June 17, 2011
Use SSIS system variables effectively
Package variables are an important piece of component to create dynamic SSIS packages. There are two types of variables inside SSIS, system variables and user defined variables. System variables are not editable but can use as read only variables. The values of the system variables are set by the package for the purpose of tracking metadata such as Package ID. Effective use of system variables increases the performance of SSIS packages and using system variables is a good development practice as well. A list of system variables included in SSIS is mentioned bellow.
Subscribe to:
Post Comments (Atom)
How do I use the CancelEvent to end the package execution?
ReplyDeleteNotify me
ReplyDeleteNice blog... In Forex trading strategy is so important, that if trader want to make money then follow a great strategy.
ReplyDeleteintroducing brokers introduce new clients to a Forex brokerage, and in return the Introducing Brokers earn a generous, ongoing commission
ReplyDeleteAll thanks to Mr Anderson for helping with my profits and making my fifth withdrawal possible. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options. it is a highly lucrative business which can earn you as much as $2,570 in a week from an initial investment of just $200. I am living proof of this great business opportunity. If anyone is interested in trading on bitcoin or any cryptocurrency and want a successful trade without losing notify Mr Anderson now.Whatsapp: (+447883246472 )
ReplyDeleteEmail: tdameritrade077@gmail.com