Thanks :-)!!!!!!! i used the 2nd one and it works

Thanks Dave:-). The code is now working if i delete @ResultSet for each iteration.

I do have another problem. There are few Invalid CreditCard Numbers (i.e ESP returns error) in...

Thanks Jeff for the reply.

The above code is only updating the 1st row with the encrypted value and i also get these errors:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Msg...

Thanks a lot. I figured it out last week 🙂 and my package is working.

I am completely stuck and would appreciate any help!

Thanks a lot Tim. I will try this technique.

I would need some help with the expression as i am new to it.

I tried creating a variable(varFile):

@[User::FilePath] +

+ RIGHT((DT_WSTR,4)YEAR(GETDATE()),2) + (DT_WSTR,2)MONTH(GETDATE())...