In previous versions of SSIS, if we wanted to manipulate
SSIS variables in a Control Flow, we would need to use a script task. This required some .NET programming knowledge. New version of SSDT a new task is introduce, known as Expression task. With the
help of this task we can evaluate the expression dynamically in control flow.
Here I am taking simple example. I have a package and I want
to store the package name and when it gets executed in the database. With the
help of Expression Task I am evaluating some expression and storing it on the
table.
Let’s see the example
Here I am taking two Expression Task
First for getting the execution time of the package and
second one for getting the current package name.
I am taking to variable.
Package name and Package description
Now we need to set customize dynamic value to the variable
using Expression task.
Double click on the Expression task.
Set the value and evaluate the expression.
Similarly we need to set the values of the package name.
Now we get the both value. We need to insert these values in
the table. For inserting the values in a table I am using Execute SQL task.
Table structure
create table
PackageInfo
(
ID int
identity(1,1),
PackageName varchar(100),
PackageDesc Varchar(500)
)
|
Taking Execute SQL Task
Creating the connection
Providing the SQL statement.
Mapping the parameter
Click ok.
Package is ready to execute.
Package executed successfully.
Let’s see the result in table
