Hi, Can any one explain me with example for the following features in SSIS. 1)Direction in execute sql task's parameter mapping:What is the use of output,returnvalue?parameter value is only for passing a value to query rignt? 2)parameter size in Execute Sql task's parameter mapping. 3)Force Executionvalue.  

Direction is for setting a parameter as input or output, for example you can have input / output parameters in your stored procedure and then you can pass input parameters from package's variables and get the output parameters into other package variables. parameter size is for limiting the size of parameters, when nothing set there, then default value will be used. an example of executionValue : http://sql-bi-dev.blogspot.co.nz/2010/10/executionvalue-and-execvaluevariable-in.htmlhttp://www.rad.pasfu.com

Direction is for setting a parameter as input or output, for example you can have input / output parameters in your stored procedure and then you can pass input parameters from package's variables and get the output parameters into other package variables. parameter size is for limiting the size of parameters, when nothing set there, then default value will be used. an example of executionValue : http://sql-bi-dev.blogspot.co.nz/2010/10/executionvalue-and-execvaluevariable-in.htmlhttp://www.rad.pasfu.com

Hi NikkRED, Besides Reza Raad's professional suggestion, I would like to share more information about the question. ReturnValue: A stored procedure can return an integer value, called a return code, to indicate the execution status of a procedure. To implement return codes in the Execute SQL task, you use parameters of the ReturnValue type. Output Parameters: Output parameters allow you to retrieve values from a stored procedure after the stored procedure finishes executing. Output parameters can be any data type. This makes them more useful than the return value which only returns an int data type. You can have multiple output parameters. For more details about it, please see: http://www.sqlservercentral.com/articles/Stored+Procedures/outputparameters/1200/ Forced Execution Value: The properties in this category configure an optional execution value for the package. Details please refer to: http://msdn.microsoft.com/en-us/library/ms137749.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.