70-458 · Question #145
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in…
The correct answer is A. Script Task. The Script component extends the data flow capabilities of Microsoft Integration Services packages with custom code written in Microsoft Visual Basic or Microsoft Visual C# that is compiled and executed at package run time. The Script component simplifies the development of a…
Question
Exhibit
Options
- AScript Task
- BConditional Split
- CMulticast
- DSource Assistant
How the community answered
(44 responses)- A75% (33)
- B5% (2)
- C14% (6)
- D7% (3)
Explanation
The Script component extends the data flow capabilities of Microsoft Integration Services packages with custom code written in Microsoft Visual Basic or Microsoft Visual C# that is compiled and executed at package run time. The Script component simplifies the development of a custom data flow source, transformation, or destination when the sources, transformations, and destinations included with Integration Services do not fully satisfy your requirements.
Topics
Community Discussion
No community discussion yet for this question.