How can I batch precreate password using HashAlgorithm when creating data package?

Question

Dear All Once a member registered on our site we encrypt the user inputted password using HashAlgorithm store this user's info along with password to tblMember. Password is a required field. Now I have a HR file and wants to precreate member accounts with giving password. I can create a SSIS package to include all the other info but has difficult time with this password. Is there anyway I can generate those passwords with hash/salt when creating data package like include the password dll in package solution ? If it does how? Thank you in advance for your time. Ellen

Ellen Hu · Answer

Here is my solution in case some one is on the same situation: In our application we have the hash algo to encrypt user password. Thus I created a function within our login page to generate all password to a temp table along with userID's. From there create a SSIS package transfer those data to server. Thank you for looking my post. Ellen