 | |
DTS problem - "transaction context in use by another session" erro
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS problem - "transaction context in use by another session" erro -
10-14-2004
, 05:15 AM
#2
| |||
| |||
|
|
I have created a DTS to load data from files managing transactions and using lookup queries on several tasks. I receive the following error for the tasks having lookup query defined : transaction context in use by another session. Any suggestion? Ciao, Adele |
#3
| |||
| |||
|
|
-----Original Message----- Make sure you are using seperate and distinct connection objects for the lookup queries. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Adele Ciaffone" <Adele Ciaffone (AT) discussions (DOT) microsoft.com> wrote in message news:EC84A98A-50E3-4B25-99D2- 0C7012F99F80 (AT) microsoft (DOT) com... I have created a DTS to load data from files managing transactions and using lookup queries on several tasks. I receive the following error for the tasks having lookup query defined : transaction context in use by another session. Any suggestion? Ciao, Adele . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.