O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Expression Task

The Expression Task is one of the SSIS Control Flow Tasks. The reason why we excluded it from Chapter 2, Control Flow Tasks, is that this task works only with expressions and variables and is much more relevant to this chapter.

The Expression Task provides a way of setting a variable's value with an expression. This is a handy task and was added recently in SSIS 2012. Besides the fact that this task didn't exist in the previous versions of SSIS, there was an alternative solution for same cases, which is used frequently.

In this recipe, we will create a filename based on the date of running the package and combine it with a folder path to create a full file path.

How to do it...

  1. Create an SSIS project and name it R04_Expression ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required