If you’re an SSIS developer, you are always looking for ways to save time in development, so you can utilize that time in other areas.
Today, let’s look at a simple solution for when you want to have several packages kick off sequentially. One way to schedule all these items is to use SQL Agent Jobs, but what if there was a way to put all our packages inside a single control flow?
With Task Factory, you can. With Task Factory’s Advanced Execute Package Task, you can use the packages themselves as components inside of your package environment instead of using control flow task.
In this demo, I’ll walk through how to kick off a number of packages sequentially, where I can set up success or failure options for them. This is a great way to simplify the entire process by having a master execution list.
- I’ll start off inside of Visual Studio and you’ll see a container housing all my different advanced execute package tasks. I named it Master Package, but it contains a bunch of other packages including my Dimension Merge, Slowly Changing Dimension, Address Parse, among others.
- I’m utilizing some of the packages I’ve created using Task Factory components and I want to execute them all sequentially from a single master package.
- You could use a SQL Agent Job and go through and configure multiple package executions, but I’m using the Advanced Execute Task component to save time by only having to kick off a single package and speed up ETL.
- Now, I simply execute my Master Package containing all my other packages and it will go through automatically and execute each one individually. Instead of having to kick off each of my components, I can execute them all at once.
It’s that simple to use the Advanced Execute Task to simplify your ETL by creating your own Master Package executions. Task Factory has over 65 time saving components; I’m sure you can find many ways to utilize the time saved in development. If you want to learn more about Task Factory, or to download a free trial, click the link below or visit pragmaticworks.com.
Already using Task Factory and have a question on a component? When you open a component inside of Visual Studio, just click the blue question mark icon, which will bring you to our help page http://help.pragmaticworks.com with documentation on all the Task Factory tools. At Pragmatic Works, we do all we can to simplify your life with SSIS.