You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by
using the least amount of development effort.
What should you use?
A.
Expression task
B.
Script task
C.
Execute SQL task
D.
Execute Process task
E.
Term Extraction transformation
Explanation:
http://msdn.microsoft.com/en-us/library/hh213137.aspx
C. Execute SQL task (to change a variable value / least amount of development effort)
Expression task is just an evaluation
0
0
Sorry, A. Expression Task is OK. Only since 2012 and I misunderstood how it worked.
0
0
A. Expression task
0
0
We have here 3 potential correct Answer A/B/C.
If we choose B: we’ll have to do the following actions :
==> Configure the variable as WriteOnlyVariable
==> Edit the script (VB or C#) to calculate the runtime value
==> Build the script
If we choose C: we’ll have to do the following actions :
==> Configure the EXECUTE SQL TASK Result as “Single Row”
==> Write the SQL query that will return the value in the variable
==> Map the variable in result pane to take the value returne from SQL Task
As mentioned above, B and C take a lot of effort.
Hence A is the right Answer !!!!
0
0