Hi,

I've got a big problem with SQL Server 2000 DTS and I hope that you
could help me.
I'm making a package (PKG A) calling an another one (PKG B) using à
Data Driven Query. When I run PKG B alone it works perfectly and there
is no problem, that's perfect. But when I run it from the PKG A I have
this error:
"Error Source: Package Microsoft Data transformation Services (DTS)
Error Description: the execution canceled by the user" (it is not the
real error message but a translation because I'm using a french version
of DTS)
I traced in the package the error and I found that it comes from the
Data Driven Query task. All I am doing in this task is an update like
that:
DTSDestination("COD_GRP") = DTSSource("COD_GRP")
DTSDestination("LIB_GRP") = DTSSource("LIB_GRP")
Main = DTSTransformstat_UpdateQuery
(my two tables have the same column name)
and in the update request I'm doing this:
UPDATE TD_GRP_PRODUIT_MKT
SET LIB_GRP_PRODUIT_MKT = ?
WHERE
(COD_GRP_PRODUIT_MKT = ?)

That's all.

Does anyone have an idea of where my problem and how can I solve it ?

Thanks in advance for your answers.


Sincerly,


--
Kurt

I almost forgot: it is a dynamic data driven query task. But I checked
each variable, I checked the dynamic property task and the variables
have the right value.

Thanks in advance for your answers.

Sincerly,
--
Kurt

Kurt a écrit :

Set all the tasks to Execute on the Main Thread is usually a starter for
this one.


--


Regards



Allan Mitchell


Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com


"Kurt" <nicolas.agrapart (AT) gmail (DOT) com> wrote