how to pass multiple parameters in stored procedure through ssis

In Execute SQL task.. if you have three parameters means..

In Execute SQL task.. if you have three parameters means..

Kingxxx1 has given you a good visual snapshot of how your store procedure call should look like in SSIS. Just to add a little more to it, Kingxxx1 has used OLEDB Connection but you can also use ADO.NET Connection. For that there is a different way to set the parameters. there are a lot of tutorials you can look at online for that. Even though use ADO.NET connection seems to be more natural to be used with SSIS being a Microsoft technology but it has its own pros and cons. Most of the developer chose to use OLEDB connection anyways as it give them more freedom to do certain tasks which are hard to do with ADO.NET connection.Please mark the post as answered if it answers your question

Kingxxx1 has given you a good visual snapshot of how your store procedure call should look like in SSIS. Just to add a little more to it, Kingxxx1 has used OLEDB Connection but you can also use ADO.NET Connection. For that there is a different way to set the parameters. there are a lot of tutorials you can look at online for that. Even though use ADO.NET connection seems to be more natural to be used with SSIS being a Microsoft technology but it has its own pros and cons. Most of the developer chose to use OLEDB connection anyways as it give them more freedom to do certain tasks which are hard to do with ADO.NET connection.Please mark the post as answered if it answers your question

just to add more information to Kingxx1 and DotNetMonster, you can see list of all parameter names and parameter markers for different connection types in this link: http://technet.microsoft.com/en-us/library/ms140355.aspx parameter marker is the character or set of characters that you use in the sql query, like question mark in the screenshot above. and parameter name is the index that used in the parameter mappings tab, like 0,1,2 in the screenshot above.http://www.rad.pasfu.com

just to add more information to Kingxx1 and DotNetMonster, you can see list of all parameter names and parameter markers for different connection types in this link: http://technet.microsoft.com/en-us/library/ms140355.aspx parameter marker is the character or set of characters that you use in the sql query, like question mark in the screenshot above. and parameter name is the index that used in the parameter mappings tab, like 0,1,2 in the screenshot above.http://www.rad.pasfu.com