Sumithav29

 Profile Answers by Sumithav29 

• Jun 12th, 2009

 

There are three types of data that pass between the Integration Service and the stored procedure:

1. Input/output parameters: For many stored procedures, you provide a value and receive a value in return. These values are known as input and output parameters. It sends and receives input and output parameters using ports, variables, or by entering a value in an expression.

2. Return values: Most databases provide a return value after running a stored procedure. Depending on the database implementation, this value can either be user-definable, which means that it can act similar to a single output parameter, or it may only return an integer value.

3. Status codes: The stored procedure issues a status code that notifies whether or not the stored procedure completed successfully. You cannot see this value.