i guess you are taking about the Procedure

sp_help_revlogin not the one you have mentioned. This Procedure is used to transfer the logins from one server to another server. the result of this SP will Provide a script that need to execute in the other database in another server.

You can refer this URL for more info on this SP.

http://support.microsoft.com/kb/918992

Did You correctley mapped the result set in the Execute Sql Task.