70-448 · Question #239
You maintain a SQL Server 2008 Integration Services (SSIS) instance. You develop a package that creates the temporary table employee_stgl and then loads the data from an Excel source data flow task…
The correct answer is A. Set RetainSameConnection to True. C. Set DelayValidation to True. A: ConnectionManagerOleDbClass.RetainSameConnection Property Gets or sets a Boolean that indicates whether the connection manager retains the same connection. C: DtsContainer.DelayValidation Property Gets or sets a Boolean that indicates whether validation of the task is…
Question
You maintain a SQL Server 2008 Integration Services (SSIS) instance. You develop a package that creates the temporary table *employee_stgl and then loads the data from an Excel source data flow task into *employee_stgl by using conditional transformation splits. The package then loads the data into a destination table. When you try to open the package, you get an error that reads, "Invalid object name #employee_stgl." You need to resolve this error message. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Options
- ASet RetainSameConnection to True.
- BSet RetainSameConnection to False.
- CSet DelayValidation to True.
- DSet DelayValidation to False.
How the community answered
(26 responses)- A77% (20)
- B8% (2)
- D15% (4)
Explanation
A: ConnectionManagerOleDbClass.RetainSameConnection Property Gets or sets a Boolean that indicates whether the connection manager retains the same connection. C: DtsContainer.DelayValidation Property Gets or sets a Boolean that indicates whether validation of the task is delayed until run time. The default value is false. Note: Validating the package before it runs is a way of finding some errors before execution starts. However, it processes the package to find errors, and if no errors are found, the package runs. Because this goes through the package two times, validating a package increases the amount of processing for the package, so should be used only when necessary.
Topics
Community Discussion
No community discussion yet for this question.