hi all
i am having one doubts related to scheduting of DTS.

I have one stored procedure where i am inserting values into 6 tables.

i have created dts for this stored procedure and scheduled this dts.

my question is when my sp is running and i stopped the job in between
that means after completly inserting records into 3 tables and not in
remaining 3 tables.

Is stopping of job rollbacking the insertion.

or it is throwing any exception. if yes how to prevent job from
stopping before completion of insertion.

any help will be truely appreciated.

thanks in advance.