Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > DTS Transformation Error: "Transaction context in use by another session."

Reply
Thread Tools

DTS Transformation Error: "Transaction context in use by another session."

 
 
Axel Dahmen
Guest
Posts: n/a
 
      02-07-2005
Hi,

today I've had a strange DTS error: In one of my transformations I'd been
using several Copy Column transformations + one ActiveX transformation using
a lookup function. This lookup function uses a second connection to the same
SQL server but to a different database. I'm using this function to populate
a new column in a table with calculated values.

The transformation didn't run, I got an "Transaction context in use by
another session." error, which seems to be quite popular. I found the
solution for that error in Google quickly. But I'm not satisfied with the
solution:

If I uncheck the "Join transaction if present" checkbox, this task no longer
runs in my transaction context. This is definitively not what I want. I
guess it's a bug in SQL Server 2000.

Can someone, who has experience with SQL Server 2003, please tell me if MS
got rid of this problem in SQL Server 2003? So is it worth to migrate in
this sense?

TIA,
Axel Dahmen


 
Reply With Quote
 
 
 
 
Axel Dahmen
Guest
Posts: n/a
 
      02-07-2005
.... Sorry, wrong NG!!


 
Reply With Quote
 
 
 
Reply

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Day! DTS Criterion DAZED & CONFUSED dvd, Ltbx THE SHADOW DTS LD, Criterion BOOGIE NIGHTS ld J Rusnak DVD Video 0 01-02-2007 11:30 PM
FA: DTS THE SHADOW ltbx LD, DTS DAZED & CONFUSED Crit. DVD, Criterion BOOGIE NIGHTS LD J Rusnak DVD Video 0 12-28-2006 05:30 PM
FA: DTS ANACONDA Superbit, Factory-Sealed DEEP RISING dvds, DTS CARLITO'S WAY ld J Rusnak DVD Video 0 04-11-2006 02:30 AM
The Jackal (1998) DTS vs non-DTS Aphelion DVD Video 2 04-07-2005 01:44 AM
Re: Matrix DTS and Matrix 2 DTS? PeterTHX DVD Video 0 08-03-2003 05:46 AM



Advertisments