Sql Server Programming :: Update through dts import/export


	Update through dts import/export Hi .. i want to update the destination table DT from source table ST in the same DB . after setting both the connections .. i selected the "user a query ....for data transfer " then i wrote my update statement mentioned below .. UPDATE pb SET pb.C1 = tt.C1 FROM test tt INNER JOIN tblpayer pb ON pb.PayerID = tt.PayerD i checked for parse query , after that i set the detination table to DT and clicked on transform , dont know what to set here in transform so did nothing . cliked on next and finish .. i throws an error "Invalid Pointer " note : here source table have 10 fields and destination table have 2 fields with a primary key .. and i dont want to update through query i need a dts wizard for updation can anyone help me out ? thnx in advance vizay If they are in the same DB you should only need one connection and then you need an execute SQL task linked to it. Then put your code in the execute SQL task. It's not a data transformation so you don't want any transformation tasks. Nigel Ainscoe <kvi@gmail.com> wrote in message news:1173093533.870755.200710@c51g2000cwc.googlegroups.com... - Hide quoted text - > Hi .. > i want to update the destination table DT from source table ST in the > same DB . > after setting both the connections .. i selected the "user a > query ....for data transfer " then i wrote my update statement > mentioned below .. > UPDATE pb SET pb.C1 = tt.C1 FROM test tt > INNER JOIN tblpayer pb ON pb.PayerID = tt.PayerD > i checked for parse query , after that i set the detination table to > DT and clicked on transform , dont know what to set here in transform > so did nothing . cliked on next and finish .. > i throws an error "Invalid Pointer " > note : here source table have 10 fields and destination table have 2 > fields with a primary key .. > and i dont want to update through query i need a dts wizard for > updation > can anyone help me out ? > thnx in advance > vizay