Quiz 70-458

Quiz 70-458, Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes

Which event handler should you use?

Which query should you use as the data source?

Which destination should you use?

You need to add the new capability to all the packages without copying the code between packages

Which data flow transformation should you use?

Which page of the Lookup Transformation Editor should you select to configure the query?

How should you develop the data flow?

You need to complete the mapping of the Team Type column

Which type of attribute should you create?