- Steps to load the waitlist data into the WaitLists_by_PID table:
Login to SSOL Waitlist view - You must have access to SSOL and have access to all courses mounted in SPS.
...
Execute the integration service package called WaitLists_by_PID.dtsx - this script will delete the current data in the WaitLists_by PID table and replace it with the current downloaded file.
- How to change the @waitlist_term_id manually in the a2_crt_pb.sql procedure
Open the a2_crt_pbi procedure, and look for the @waitlist_term_id variable, and change it to the current term.
...