A Better Way to Execute SSIS Packages with T-SQL

We think of SSIS packages as something you build in Visual Studio, deploy to Integration Services and run from a SQL Server Agent job. Did you know that you can execute packages from within a T-SQL procedure?

Check out this demonstration on how to accomplish this.

https://www.timmitchell.net/post/2016/11/28/a-better-way-to-execute-ssis-packages-with-t-sql/