Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

  1. 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.

Scroll to the bottom of the page and click on:

Once the page loads scroll to the bottom of the page and click on the "download" link located on the bottom left.

Once the csv file is downloaded to your local computer move the file to I:\DATA_IMPORTS\Waitlists on the H drive

Delete the existing Waitlists.csv file and rename the current file to WaitLists.csv

Login to the terminal server and use file explorer to view I:\DATA_IMPORTS\Waitlists on the H drive

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.


  1. 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.

For example, if @waitlist_term_id  is 20241 then change it to 20242 and save the stored procedure.





  • No labels