dbTalk Databases Forums  

DTS transaction commit/rollback

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS transaction commit/rollback in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
goncalo
 
Posts: n/a

Default DTS transaction commit/rollback - 04-06-2004 , 09:16 AM






Hi
I'm having a problem due to concurrency in DTS

I have several processes running in parallel where every one of them calls the same DTS

My problem is that I can't control the data manipulated on DTS transaction 'cause I'm not able to control it and the data created on the same transaction. That data is not transactional related. :

I tryed using Serialazable isolation level, and set every workflow to 'join transaction if present', but not working

Thank's in advance

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.