Hi all and happy new year.


I've got a problem to join transactions in a package.

In a package, I've got two OLEDB connections to the same database (sql2k) to
tranfer Data from one table to another with a DataPump.
I've checked 'Join Transaction if present' in the workflow properties of my
DataPump.

The job fails when I want to transfer 200 or 300 rows.

The error is (in French) :

La connexion « SQL2K » pour la tâche « DTSTask_DTSDataPumpTask_1 » ne gère
pas la jointure de transactions distribuées ou a échoué lors d'une tentative
de jointure. (Microsoft OLE DB Provider for SQL Server (8004d00a): La
nouvelle transaction ne peut pas s'inscrire dans le coordinateur de
transactions spécifié. )

--> It means that DTS is unable to deal with the distributed transactions.
MSDTC is running on the machine.

What is surprising me is when there are only 40 or 50 rows to transfert, it
works !
It work too with hundreds of rows when I uncheck "Join Transaction if
present".

Is there a size limitation for this kind of transactions ?


Thanks for your help

--
Regards

Oxiane
----------------------------------------------------------
Omnia vanitas

I've found the solution.

see :
http://support.microsoft.com/?scid=h...ticle%3D279857



That's clear enough : "... the error does not occur when the rowcount is
small. "



--
Regards

Oxiane
----------------------------------------------------------
Omnia vanitas


"Oxiane" <fgregoire (AT) enlever_ceci (DOT) freesurf.fr> a écrit dans le message de
news:uy7Zbbb8EHA.1596 (AT) tk2msftngp13 (DOT) phx.gbl...