Thanks very much for taking the time to answer my questions.
As you mentioned I have other posts happening in the forum now that are serving to document my learning journey here…
I’m trying to get an asp.net core 6 demo of what I want up and an running … the progress could be followed here
I eventually hope to be able to make a contribution in the form of a completed example.
As for the “different command line” I apologise for the ambiguity… all I meant was that I need to pass params to the jobs. I think I can see how that would be done now.
Also, for the ETL tasks, I hope to code them myself in the jobs and a lot of what we want to do is non-standard so I figured it would be the best approach.
As and aside though, if you can reccomend any ETL specific frameworks I would be interested to take a look… because of the quirky nature of our equipement set-up things like SSIS and BI are not available to us as options … hence the interest in looking at open source options like this.
Thanks again for your input… its greatly appreciated. 