<div>
<div class="content wysiwyg-content">
Using DTS, how can I make it so I only commit transactions on successsful completion of the whole package and all 10 seperate transactions? &nbsp;i.e. if 1 dts fails, then all previously successful transdactions are rolledback?<br />
<br />
Many thanks<br />
<br />
P
</div>
</div>


Using DTS, how can I make it so I only commit transactions on successsful completion of the whole package and all 10 seperate transactions?  i.e. if 1 dts fails, then all previously successful transdactions are rolledback?

Many thanks

P

DTS - commit all transactions only on successful completeion of whole package

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.