Hello!
I am trying to set up a package that would insert new user accounts from an Excel file into the appropriate SQL2k table. I'd like to include some error handling to catch when a new record tries to use a taken userID (which is the prmary key in my table). Ideally, the package would return a list of userIDs that were already in the DB. Any thoughts?