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.)
A.
Set RetainSameConnection to True.
B.
Set RetainSameConnection to False.
C.
Set DelayValidation to True.
D.
Set DelayValidation to False.
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.