>-----Original Message-----
>It will only roll back uncommitted stuff so if each task
is its own
>transaction then that is all that will be rolled back.
>
>--
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.SQLDTS.com - The site for all your DTS needs.
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:630a01c42e17$ddf2d120$a001280a@phx.gbl...
>> I've just set a DTS package to copy one database from a
>> sql7 server to a sql 2000 server. After 5 hours its
>> finally copied 90% of the tables including one with 12m
>> lines, but it's now just started to create huge tables
>> out of the views. I need to cancel the views on 2
>> fronts - not much disk space left or physical time.
If I
>> cancel the DTS will it rollback all the previously done
>> tables, (particulary the 12m one) or will it just roll
>> back to the start of the views?
>>
>>
>>
>
>
>.