From the course: SQL Server Integration Services
Join today to access over 24,600 courses taught by industry experts.
Run packages with T-SQL - SQL Server Tutorial
From the course: SQL Server Integration Services
Run packages with T-SQL
- [Instructor] Triggering packages to run with T-SQL commands is a useful technique. With this method, running SSIS packages can be incorporated into other scripts and procedures, executed on the server remotely, or through external programs. The Transact-SQL that you need to execute is a little bit complex if you were to write it out manually. But once you have your packages deployed to the server, and can execute them here in Management Studio, it's really simple to have the proper syntax generated. First you need to find the package that you want to run with a T-SQL command. Then, right-click it and choose Execute, just like you would if you were running it immediately. But on this window, instead of coming down to the OK button on the bottom, instead what we're going to do is come up to the top and click on the downward pointing triangle next to the script button. This will allow you to write out the command to a new query window, or export it to a file or your clipboard. I'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.