Using System.Web.Security.Membership.DeleteUser In SSIS Package Script Component

Hi

I have to import a list of users and then add them to my Sql database via .NET framework APIs
Now the following code works from within my web application but I cannot get it to run in an ssis transormation script.

Has anyone got experience with this requirement in an SSIS package script?





Code Block

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)


Static users As New System.Collections.Hashtable

Dim password As String = String.Empty


If (Not users.ContainsKey(GetUserCode(Row.UserID))) Then



users.Add(GetUserCode(Row.UserID), GetUserName(Row.FullName))


'create a random password

password = System.Web.Security.Membership.GeneratePassword(7, 1)


Try


'insert new user

System.Web.Security.Membership.DeleteUser(GetUserCode(Row.UserID))

System.Web.Security.Membership.CreateUser(GetUserCode(Row.UserID), password)


'link roles to new user

System.Web.Security.Roles.AddUserToRole(GetUserCode(Row.UserID), "MANAGE_SCORECARD")






Catch ex As Exception


System.Windows.Forms.MessageBox.Show(ex.Message)

End Try

End If

End Sub