Home Forums Programming SMO/RMO/DMO SMO within SSIS Script Task - User.Drop() causes error at runtime. RE: SMO within SSIS Script Task - User.Drop() causes error at runtime.
Todd Engen
SSCrazy Eights
Points: 9869
More actions
February 19, 2008 at 11:37 am
#779857
Replacing the For Each loop with a For Next loop should work.
Dim usr as User
For x As Integer = db.Users.Count - 1 to 0 Step -1
usr = db.Users(x)
If Not usr.IsSystemObject Then
usr.Drop()
End If
Next x