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.