SSIS Self Test question-control flow control class

Description: The following is your own understanding of the answer, not the standard answer, if there are inappropriate please point out.

Some topics for the time being no answer, have to know please leave a message, learn from each other, progress together.

62, describe the role of Execute SQL task, in the ETL development process in which cases will be used to execute SQL task?
Execute SQL statement, get single data, get data collection
63. What kinds of Direction are there in Parameter Mapping in Execute SQL Task?
Three kinds: Input, Output,returnvalue
64, how to configure the parameters of Execute SQL Task, what is the function of Parameter Name in Parameter Mapping?
Call for sub-convenience parameters
65. Call a stored procedure with an output parameter in the Execute SQL Task, which Direction should be configured for this output parameter in configuration Parameter Mapping?
Output
66. How do I get a stored procedure in Execute SQL Task with return value with the returned values?
Using OUTPUT parameters
67, if you want to record the start time of a package, the execution end time is the unique ID of the package execution, and the final execution state of the package, which system variables should be used, and how to implement this basic log record?
Starttime,guid,
68. What are the four types of result set in Execute SQL Task, with examples illustrating the usage scenarios for each type of result set?
None, single row, full data set, XML
69. How to save the full Result Set returned by the Execute SQL Task in a variable, which type of variable should be used to save?
Object
70. How do I traverse the full Result Set returned in the access Execute SQL Task, with two basic implementations?
The foreach line traversal, script traversal, load result set to table, Traverse table
71. Under what circumstances will the parent package and the child pack be used to use the benefits of parent-child pack design?
You can change the configuration value of a package at run time
72. If you need to pass the parameters of the Parent package to the child package, which configuration option is required to open the package?
Parent Package Variable
73. What is the change in SSIS ETL 2012 for the first open and second open location of the package Configuration?
No changes found
74. In the package configuration Wizard, what types are configured in the config type, and which one should be chosen when configuring parent-child packages?
XML configuration file, SQL SERVER, environment variable, parent package variable, registry key
75. How do I pass the values in the Parent package to the variables in the child packages?
Formulating Parent Package variables
76. How to invoke the child package in the Parent package, and which control to use in the control flow?
Control Flow Page Add "Execute Package Task"
77. What are the three stages of assigning a value to a package variable?
Initial value Assignment
Package Run Assignment
Script Assignment
78. How do I assign a value to a variable in a package before the package runs?
Set default values for variables
79. What control flow control calls can be assigned to a variable by the return value after the call ends?
FOREACH, Execute SQL task
80, how to assign a value to a variable in the process of running the package, which control flow control can be used?
Execute SQL Task
81. What are the basic actions that the file System Task can do to the files in the control flow?
Copy directories, delete directories, delete directory contents, move directories, create directories, copy files, delete files, move files, rename files, set properties
82. How do I get all the file names under the specified directory in the Script Task, or specify the file name of the file suffix type?
Fileinfo,directory.getfiles (Path,pattern)
83, in the SSIS six ETL, the XML Task has the six operation type operation type, what are the respective roles of the different types?
Validate,xslt,xpath,merge,diff,patch
84, XML Task, how to use the Validate operation to validate an XML file?

85, XML Task, how to use XML stylesheet to format the XML file, what is the role of the XLST file?
86. Xml Task, how to use XPATH to find and extract the contents of the XML file, such as how to return a node, or node collection, value, etc.?
87. In XML Task, how do I use the merge operation to merge the contents of two XML files into a third new file, or insert the contents of the XML file into a location specified by another XML file?
88, XML Task, using the diff operation to compare two XML files, what can output? What do these content describe separately?
89. In XML Task, what kinds of XML files do you generally need to participate in using Patch operations? What should be the contents of these XML files, respectively?

90. Describe the scenario using Send Mail Task?

91. What are the limitations and limitations when using Send Mail Task?

92. What type of connection do I need to establish to use the Send Mail Task?
SMTP Connection Manager
93. Can I send a message type with an attachment using Send mail Task?
can send
94. What is the role of Event Handler in SSIS? What is the role of the OnError event, and what problems can we use OnError to deal with?
According to the event triggered by the program, to deal with the corresponding thing
When a program exception error occurs, an event is triggered that catches an error.
95, what is the Scope of the variable? What is the difference between a variable under scope in a control flow control and a variable in the OnError scope?
Scope: Refers to the range of variables that work.

96, if you want to access the non-domain non-Windows authentication under the SMTP server and send mail, in the SSIS ETL what kind of way can we use?

97. In the control flow Script Task, does the default reference namespace contain a reference to windows.forms?
Is
98. What is its Entry point in the control flow Script Task? What is the function of this method?
Main, method that the runtime calls as the entry point for the Script task code
99. What does ReadOnlyVariables and readwritevariables mean in the control flow Script Task?
ReadOnlyVariables: read-only variable
Readwritevariables: Readable writable variable
100, how to debug scripts in the script Task, what are the two basic ways to debug the process is what?
To set breakpoints in code
To set breakpoints in a script task
101. What is the bug of Script Task which has a bug from 2008, 2008R2 version to version 2012 in SSIS?
The read-only property of the variable, which will work only after setting readonly=true
102, in the SSIS project ETL, for the validation of parameters generally, why the need for these validation, what is the role?
If a project or package encounters an unresolved parameter value, no validation causes the package execution to fail.
By validating, you can confirm that all parameters have required values that the person can use to resolve the required values using a specific environment reference.
103, in your project, the validation of the file class generally have what, respectively, please describe the verification process?

104. Describe the role of the Execute Process Task of the SSIS system ETL control flow, what can we do with it?
Executes the command line, or executable file. exe.
105. How do I use Execute Process Task to implement compression and decompression operations?
The ZIP7 is called directly by command to decompress and compress.
106. What is the purpose of the For loop Container? It is similar to which syntax in a programming language, what are the three basic configurations?
Loop through the values, for loop, starting value, judging condition, ending value
107. Can I cycle the time in the For loop Container? How is it implemented?

108. What is the most common usage scenario for the Foreach Loop Container? How do I use the Foreach loop Container to loop and traverse files of the same type in the specified directory?
Folder traversal, multiple foreach loops
109. Describe the iterator enumerator in the Foreach Loop Container you know, what are the possible types?
Files, item,ado,ado.net NodeList
110. In the foreach Loop Container, when is the foreach File enumerator primarily used?
Traverse directories and files under a folder
111. In the foreach Loop Container, when is the foreach ADO enumerator primarily used? What are the special requirements on the type of the cyclic variable?
Enumerates the rows in a table or table, and the type of the loop variable is object.
112. In the foreach Loop Container, when is the foreach from Variable enumerator mostly used? What are the types of variables that are required on the loop, for example, to illustrate the scenario used?
Enumerates the values in a variable, enumerating the variables of the XML
113. In the foreach Loop Container, what kind of problems can be solved by using the foreach ADO Schema Rowset enumerator? Please illustrate.
Enumerate the values of the ADO schema
114. What is precedence Constraint precedence constraint? Is it used in the control flow or in the data flow? What is the role of it?
Precedence constrains the executable file, container, task in the control flow that links the package, and specifies the conditions that determine whether the executable is running.
115. What are the two options for constraining precedence Constraint precedence constraints, and what are the effects respectively?
Expressions and Constraints
Expression: Determines the execution condition based on the result of an expression
Constraint: The execution condition is determined by the result of the value
116, precedence Constraint, Constraint constraints have what kinds of values, what is the role of each?
Success: no error occurred
Failed: Error occurred
Complete: Execution is complete
117. Precedence Constraint, how is expression constraint used?
Based on the results of the expression True/false.
118, Precedence Constraint, please describe how the Logical and and Logical or are used in multi-constraint situations.
Logical AND: True all
Logical OR: One of them is true
119. What is the purpose of using SQL profilling Task data probing? What kind of information can help us understand?
Probe database configuration information, primary key, null value, length, distribution status
120. What are the restrictions on data source connections using SQL profilling Task?
Can only be a SQL SERVER database
121. Using SQL profilling Task, what is the result of data probing usually saved in what form?
XML format
122. What kind of tools in SQL Server 2012 should be used to view the output of SQL Profilling Task?
Data Configuration File Viewer
123. What is the role of NULL Ratio profile (Null scale statistics) in SQL profilling Task, and what information can be detected by it?
Detect null values for database cells, and select a percentage of the column's Hollow values
124. What is the function of column length distribution Profiles (profilling statistics) in SQL Task, and what basic information does it contain?
Use default settings to calculate column length distributions
125. What is the role of Statistics Profiles (column statistics) in SQL profilling Task, and what basic information does it contain?
Use Selected columns to count minimum, maximum, average, standard deviation
126. What is the function of value distribution (column value distribution statistics) in SQL profilling Task, and what basic information does it contain?
The distribution of the values of the statistic columns, the number of distinct quantities, the percentage of each value
127. What is the role of the Pattern Profiles (column pattern, regular expression allocation statistics) in SQL profilling Task, and what basic information does it contain?
Regular expression value for the value of the column
128. What is the role of candidate key profile (candidate primary key Profiler) in SQL profilling Task, and what basic information does it contain?
Displays the combined strength of the candidate key, less than 100% indicates a duplicate
129. What is the role of functional Dependency strength profile (function dependency statistics) in SQL profilling Task, and what basic information does it contain?
Shows how dependent the column and dependent columns are, determining columns, dependent columns, dependency strength
130. In SQL profilling Task, what is the function of value inclusion profile, which contains the basic information?
Whether the foreign key column is valid in the gradual column
131. Is it possible to control the length type when using the Bulk Insert control, including type conversion?
Cannot control, bulk INSERT, is directly manipulate SQL via file
132. What is the efficiency of using the Bulk Insert control to insert data in the SSIS data Flow Fast load,sql Bulk INSERT statement?
Bulk Insert controls are the most efficient, followed by SSIS Data Flow Fast load,sql Bulk Insert Last

SSIS Self Test question-control flow control class