we doesn't know the value for ALIAS_ID , if you pass the TM_GUID value then the corresponding value for alias_id should result,thanks for all the help and i finally changed...

yes thats correct

CREATE TABLE [dbo].[ALIAS_TYP](

[USER_ID] [varchar](50) NOT NULL,

[EFFECTIVE_DATE] [datetime] NOT NULL,

[END_DATE] [datetime] NOT NULL,

[LOCATION_ID] [int] NOT NULL,

[TM_ID] [int] NOT NULL,

[ALIAS_ID] [int] NOT NULL,

[TM_GUID] [varchar](50) NULL,

CONSTRAINT [PK_ALIAS_TYP] PRIMARY KEY CLUSTERED

(

[ALIAS_ID] ASC

)...

thanks for quick reply but thats not what iam looking for

here is the scenario

there is a column called guid with unique values , if i pass a guid value...

thanks dwain that was very helpful and the query you provided is perfect for my scenario that i mentioned.

Perfect thank you very much,i can perform it using a query but my manager wants to do it through ssis ,anyway thanks for the solution

yes i have built the connection managers for both source and destination and i have used IBM OLEDB Provider for DB2 and where should i specify the condition

yes iam using ssis in order to do the update