Using stored procedure in ssis and data flow task.
I bring in some passwords from access. I'd like to encrypt the passwords before pushing to sql server anyone know of a way to do this. I can run the stp after i transfer. I know how to do that but i'd like to do it before i push data into sql.