search

TheDataShed / sql-deployment-tools

GNU General Public License v3.0
2 stars 0 forks source link

Decouple SSIS and SQL Agent #40

Open gvee-uk opened 2 years ago

gvee-uk commented 2 years ago

The initial implementation targeted the orchestration of SSIS pretty exactly.

But I've been thinking - what if we supported just SQL Agent in a deployment? e.g. setting up a job that runs T-SQL steps (see #39).

GooseLF commented 2 years ago

Is there a reason this couldn't be done already? Surely it would just be a case of including T-SQL Job Steps in the config instead of SSIS ones?

I guess the only thing would be the tool sets up SSISDB and SSISCatalog, I'm assuming what you mean is to make it so the above can be done where no SSISDB/SSIS Catalog is present?