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.
参考答案
正确答案：A
解析：Explanation:ItispossibletosettheCommitonsuccessfulpackagecompletioncheckboxontheAdvancedTaboftheDTSPropertiesdialogBox.ThischeckboxspecifiesthatifeachindividualSQLstatementisatransactioncompletessuccessfully,thetransactionwillautomaticallybecommitted;andifthestatementhasanerror,thestatementisrolledback.Whenthischeckboxiscleared,theDTSconnectionsoperateinimplicittransactionmodeandthefirstSQLstatementbeginsatransactionthatremainsineffectuntilDTScommitsitorrollsitback.ThenextSQLstatementexecutedafteranycommitorrollbackstartsanewtransaction.IncorrectAnswers:B:TheCommittransactiononsuccessfulcompletionofthisstepcheckboxtreatseachstepinaDTSpackageasseparate.Thus,selectingtheCommittransactiononsuccessfulcompletionofthisstepcheckboxofthecustomerstransform.datataskwouldresultinthistaskbeingcommittedregardlessoftheprogressofthesalestransformationdatatask.C:TheCommittransactiononsuccessfulcompletionofthisstepcheckboxtreatseachstepinaDTSpackageasseparate.Thus,selectingCommittransactiononsuccessfulcompletionofthisstepcheckboxofthesalestransform.datataskwouldresultinthistaskbeingcommittedregardlessoftheprogressofthecustomer’stransformationdatatask.D:TheCommittransactiononsuccessfulcompletionofthisstepcheckboxtreatseachstepinaDTSpackageasseparate.Thus,selectthecommittransactiononsuccessfulcompletionofthisstepcheckboxofbothtransform.datataskswouldresultinthetwopartsbeingtreatedasseparateandeachpartbeingcommittedregardlessoftheprogressintheother.