I am new to DTS. I have one table which has password column in it. I
would like to create the password from username.I one function which
depends on the value of username. The return value of this function
should be the password.

I would appreciate if anybody can help me out finding the DTS solution.
It needs to be DTS because I have to do the same task often.

Hello Monu,

If i had permissions I would implement a user defined function on my DataBase:

CREATE FUNCTION dbo.GeneratePwd
(
@user varchar(255)
)
RETURNS varchar(255)
AS
BEGIN
....
....
....

END



the in a DTS use an 'Execute SQL Task' to execute the statement:

UPDATE MyTable SET MyTable.Password = dbo.GeneratePwd (MyTable.User)