70-448 · Question #240
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…
The correct answer is A. Set the DelayValidation property for the Control Flow task to True. B. Set the ValidateExternalMetaData property for the OLE DB source to False. 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…
Question
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.)
Options
- ASet the DelayValidation property for the Control Flow task to True.
- BSet the ValidateExternalMetaData property for the OLE DB source to False.
- CSet the ValidateExternalMetaData property for the OLE DB source to True.
- DSet the DelayValidation property for the Control Flow task to False.
How the community answered
(40 responses)- A78% (31)
- C8% (3)
- D15% (6)
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
Topics
Community Discussion
No community discussion yet for this question.