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:
- How have you solved the problem of automating the zipping of the extract files?
- 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?
- If an upload process started before the last upload process completed, what would happen?
Thank you for your help!