Create Job using Sql Server Integration Service (SSIS) or database hack

sql-server
Tags: #<Tag:0x00007f21e4061460>

#1

Hi,

I was wondering if job can be schedules as part of ETL process like SSIS package possibally utilising NuGet?

If not, has anyone successfully tried db hack approch like replicating another existing row(s) to create another schedule?

Last approch I guess would write custom WEB API endpoint & utilise that as part of SSIS package.

Thanks


#2

Has anyone encountered this requirement?


#3

Both aproaches are posible. Particulary i do prefer the WebApi one, wich will let your package less Coupled.


#4

Can anyone share any tips on how to implement this using SSIS package?