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 3

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


ToZorMan

ToZorMan

It should be “Parameter Name : 0”

Arturas

Arturas

Connection type: ODBC
Parameter Name starts from: 1, 2, 3, …