Execute SQL Task to execute a stored procedure with parameters

When execute SQL Task executes a stored procedure with parameters, the way the parameters are passed is different, depending on the use of the link, there are two main types: OLE DB and ADO.

Createint)　　
int as on tovalues (@id)END      

1, if ConnectionType is OLE DB, then use? Represents the parameter name,? The serial number is from 0,1,2, and so on.

SQLStatement: SQL statement to execute, using? Represents the parameter,? The ordinal number is the name of the parameter.

Isquerystoreprocedure: Not selectable state, default is False

ParameterMapping: Pass value for parameter, ParameterName is? The serial number, the first one? The serial number is 0.

2, if ConnectionType is adonet, then the name of the parameter must be written in ParameterMapping, ParameterName is all characters except the @.

SQLStatement: Enter the name of the stored procedure

Isquerystoreprocedure: Optional state, check True

Parameter Mapping: Enter the parameter name in Parameter name, parametername is all characters except @

Execute SQL Task to execute a stored procedure with parameters