AnsweredAssumed Answered

SIS Upload Automation Questions

Question asked by Pam Edmonston on Apr 14, 2016
Latest reply on May 11, 2016 by Pam Edmonston

Hello all,

I'm just getting started with automating our upload to Canvas and I have some questions. I am extracting the files using an SSIS package (dtsx) and I'm scheduling it via a step in a SQL Server Agent Job. I am then scheduling the upload (via the PowerShell script) as the next step in the SQL Server Agent Job.

My questions are:

  1. How have you solved the problem of automating the zipping of the extract files?
  2. How do you know if the upload process worked? I see on the SIS Import web page that the process started, but don't see the files and numbers of records - does that only show up when the upload is complete?
  3. If an upload process started before the last upload process completed, what would happen?

Thank you for your help!