I'm a newbie on DTS.

i 'm having a access mdb with two columns one is "old_member_id" and the
other one is "new_member_id" I want to use this MDB to update the SQL table
by using the DTS: DDQ, but the problem is the member_id in the SQL's table
is a primary key. below is the code that I am using ..

Function Main()
DTSDestination("member_id") = DTSSource("old_member_id")
DTSDestination("member_id") = DTSSource("new_member_id")
Main = DTSTransformStat_UpdateQuery
End Function

UpdateQuery defined as :

update tb_redeem set member_id=? where member_id=?
with parameter1 points to member_id and parameter2 points to memebr_id

after I started the DTS it seems nothing happens and ended without any
error, but no records affected.

Please help, many thanks.


-Wing