Exam 70-463: Implementing a Data Warehouse with Microsoft® SQL Server® 2012: Training Kit by Dejan Sarka Matija Lah & Grega Jerkic
Author:Dejan Sarka, Matija Lah & Grega Jerkic [Dejan Sarka, Matija Lah, and Grega Jerkic]
Language: eng
Format: epub
Tags: COMPUTERS / Database Management / Data Mining
ISBN: 9780735666085
Publisher: Microsoft Press
Published: 2012-12-13T16:00:00+00:00
Executions
As mentioned earlier in this lesson, the execution of an SSISDB package begins with the creation of a new execution instance; the principal purpose of the execution instance is to provide a reference between a package being prepared for execution and its corresponding configuration. Another purpose is to document (log) the execution itself.
Packages stored in the SSISDB catalog are abstract entities. When an execution instance is created and a configuration is assigned to it, a concrete instance of the package is created, containing all of the information that is required for its execution. The abstract entity of a package can be executed in as many different ways as there are possible configurations, but a concrete instance of the package is executed by using a specific configuration.
When the execution instance is created, an environment containing configuration information expected by the package can be assigned to it. Only a single environment reference can be assigned to a particular execution instance.
After the execution instance has been created, additional configurations can be assigned to it. These direct assignments can target the properties of the instance, as well as the parameters and/or properties of the package being executed. For instance, direct assignments can be used to supply values to properties and parameters that are not supplied by the environment, or to override the values supplied by the environment.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Coding Theory | Localization |
Logic | Object-Oriented Design |
Performance Optimization | Quality Control |
Reengineering | Robohelp |
Software Development | Software Reuse |
Structured Design | Testing |
Tools | UML |
Deep Learning with Python by François Chollet(12585)
Hello! Python by Anthony Briggs(9924)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9799)
The Mikado Method by Ola Ellnestam Daniel Brolund(9783)
Dependency Injection in .NET by Mark Seemann(9347)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8308)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7770)
Grails in Action by Glen Smith Peter Ledbrook(7703)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7564)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(7134)
Microservices with Go by Alexander Shuiskov(6896)
Practical Design Patterns for Java Developers by Miroslav Wengner(6813)
Test Automation Engineering Handbook by Manikandan Sambamurthy(6755)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6422)
Angular Projects - Third Edition by Aristeidis Bampakos(6171)
The Art of Crafting User Stories by The Art of Crafting User Stories(5695)
NetSuite for Consultants - Second Edition by Peter Ries(5624)
Demystifying Cryptography with OpenSSL 3.0 by Alexei Khlebnikov(5437)
Kotlin in Action by Dmitry Jemerov(5071)
