You maintain a SQL Server 2008 Integration Services (SSIS) instance.
You use the Execute SQL task to create a table in a Control Flow. Following the Execute
SQL task is a Data Flow task in which an OLE DB source component uses this table.
The package fails during runtime.
You need to delay the validation of a task in the Control Flow and the OLE DB source in the
data flow.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
Set the DelayValidation property for the Control Flow task to True.
B.
Set the ValidateExternalMetaData property for the OLE DB source to False.
C.
Set the ValidateExternalMetaData property for the OLE DB source to True.
D.
Set the DelayValidation property for the Control Flow task to False.
Explanation:
The DelayValidation property is available only in executables (e.g., Control Flow tasks, the
package itself). The property isn’t available in data flow components. If you want to change
the behavior of a specific data flow component, you must set its ValidateExternalMetadata
property to False.