You are developing a SQL Server Integration Services (SSIS) package that imports data into
a data warehouse.
You add an Execute SQL task to the control flow. The task must execute a simple INSERT
statement.
The task has the following requirements:
• The INSERT statement must use the value of a string package variable. The variable
name is StringVar.
• The Execute SQL task must use an OLE DB Connection Manager.
In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the
only parameter.
You must configure the SQLStatement property of the Execute SQL task.
Which SQL statement should you use?
A.
INSERT INTO dbo.Table (variablevalue) VALUES (@StringVar)
B.
INSERT INTO dbo.Table (variablevalue) VALUES ($Project::StringVar)
C.
INSERT INTO dbo.Table (variablevalue) VALUES (?)
D.
INSERT INTO dbo.Table (variablevalue) VALUES ($Package::StringVar)
SHOULD THIS BE d OR a?
The correct answer is C.
In the Execute SQL Task Editor, on the Parameter Mapping tab, you configure properties required to run the SQL statements or stored procedures (using specified connection).
Among options that can be specified for a variable are:
Variable Name, Direction (Input/Output), Data Type, Parameter Name, Parameter Size
Once those are specified, the variable (like, StringVar), does NOT need to be included in the query text again.
only parameter
Quality posts is the key to be a focus for the people to go to see the site, that’s what this site is providing.|