Hi,
I am trying to execute an update query in an Execute SQL Task of the
following kind:

update a

set a.emploeeno=b.employeeno,
a.employeename=b.employeename
a.employeeaddress=b.employeeaddress
a.lastmodifieddate=b.lastmodifieddate

from empintranet a, temp_empintranet b

where a.employeeno= b.employeeno
and b.lastmodifieddate > ?

But i am getting error messgaes saying that "a" is an invalid name. I am not
able to set parameters also. I even tried out using "tablename.columnname".
But that did not help. Kindly let me know what can be done regarding this.

Regards,
Puja

Yeah the ExecuteSQL task is a bit funny about the aliasing in an UPDATE

Use the fully qualified name



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

I have tried using the fully qualified name. But that does not help. My table
name is of the type "temp_xyz". so when i do temp_xyz.columnname, my query
fails.

Is there any other way, i can handle this query in a Execute SQL Task?

Regards,
Puja

"Allan Mitchell" wrote: