The company wants to use Control-M, which is our standard scheduler. Control-M is Unix based. Here are the planned steps:

1. Control-M calls a PowerShell script.

2. PowerShell script calls SSIS package.

3. SSIS package processes SSAS Tabular model.

4. Status of steps 2 and 3 somehow go to a log file AND get reported back to Control-M.

A .CSV isn't totally necessary per se. However, the log file does need to be parse-able.

I created a PowerShell script that can take some parameters, call the SSIS package, tell the SSIS package which dtsconfig file to use, and what SSAS Tabular model to process. However, your approach looks a LOT cleaner and more efficient. I'll give it a try.

Thank you so much!