how should you configure the parameter?

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a
Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored
procedure has only the @CustomerID parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored
procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter?
(To answer, drag the appropriate option or options to the correct location or locations in the answer
area.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a
Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored
procedure has only the @CustomerID parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored
procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter?
(To answer, drag the appropriate option or options to the correct location or locations in the answer
area.)

Answer:



Leave a Reply 0

Your email address will not be published. Required fields are marked *