Velocity Reviews - Computer Hardware Reviews

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

Thread Tools

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

Axel Dahmen
Posts: n/a

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

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?

Axel Dahmen

Reply With Quote
Axel Dahmen
Posts: n/a
.... Sorry, wrong NG!!

Reply With Quote

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