SQL Server Integration Services (SSIS) Control Flow Templates

SQL Server

There are new features available with every new release of SQL Server. With the announcement of SQL Server 2016 CTP3, we see even more great features. In this article by Wolfgang Strasser, we learn a little more about the new Control Flow template feature.

With the announcement of SQL Server 2016 CTP3 and the available download, the first things I wanted to try are – as you can imagine – SSIS related things.

On of the most promising new features are Control Flow templates. In this blog post I will share my first learnings from using templates in SSIS. You as a a SSIS developer surely encountered the fact that you want to reuse several pieces of control flow logic again and again. Until now, reusability SSIS logic was somehow limited to the copy-past approached which definitely worked. But it only worked until you wanted to change the logic of the copied actions. And then the nightmare of refactoring began: searching for all instances of that single piece of duplicated code and then – changing the logic to the new desired state! Sad smile With the concept of SSIS Control Flow Templates the plan is to make life easier:  Control Flow Templates provide the possibility to pre-develop pieces of SSIS control flow logic that can be reused in several occurrences in one or multiple SSIS packages. 

If you want to have a look at SSIS control flow templates, you need two things – SQL Server 2016 for running those packages and the appropriate development environment (SSDT October 2015 Preview – see my blog post for more details) 

After creating a new SSIS project from scratch the new dev-environment and project structure looks like the following: 



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s