当前位置:计算机-微软认证

[单选题]You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.
The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.
You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.
You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.
You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.

What should you do
A.Select the commit on successful completion check box of the DTS package.
B.Select the commit transaction on successful completion of this step check box of the customers transform. data task.
C.Select the commit transaction on successful completion of this step check box of the sales transform. data task.
D.Select the commit transaction on successful completion of this step check box of both transform. data tasks.

相关题目

关于我们 | 网站声明 | 联系我们 | 违法和不良信息举报

Copyright © 2020 - 2022
石家庄晋咸软件科技有限公司  版权所有
冀ICP备2021011520号-1
冀公网安备 13012102000087号