Hi,

I found this code on website some time ago. I tried to find it again but am unable to do so (apologies to the original author as I am...

Sorry I forgot to mention something. In your stored procedure you did not state what value to return, thus the SP always returned a false value (zero). This...

There seems to be a problem with your SP. You did not state what value you want to return.

Try this...

Create PROCEDURE [UsernameExists]

@pUsername nvarchar(50),

@Exists bit output

AS

BEGIN

SET NOCOUNT ON;

If Exists(Select Username...

Thanks for the article Bert.

I don't often use DTS so I went ahead and did the same thing in SSIS. I followed the article just as it is written...