I am running a DTS package from a stored procedure using
XP_CMDSHELL and sending it parameters. (I just initiate
the SP from Query Analyzer). The package typically runs
properly.

When I was experimenting with the DTS package &
transaction control from DTS, I set the Package Property
to "use transactions", and I set individual workflow steps
to "Join transaction if present". On one step, I now get
an error saying "transaction context already in use by
another seesion".

What is causing this problem? Is this some conflict
between by a transaction of the Stored Procedure
initiating DTS and a transaction setup in the DTS
package?

I need to use the DTS transaction to prevent partially
committed work, which happens under the SP-transaction
only execution.

It is probably caused by you using the same connection object in > 1
transaction.



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Larry" <anonymous (AT) discussions (DOT) microsoft.com> wrote