 Hello, welcome to SSUnit app, so see this side and this is continuation of SSIS tutorial. So today we gonna discuss about Execute SQL Task Parameter Mapping. So here I have created two scenarios. First we want to insert record into a table by using variables. And second we want to execute a stop procedure with parameter. So in our first query as we can see if we want to use variables to insert record in our table then we have to specify values by question mark and then we can map those question marks with our variables. So go to on ssdt and here I would like to add one more package. So then I wish to rename this package with execute SQL Task Parameter Mapping. Now I need to drag and drop execute SQL Task then double click on this execute SQL Task. And here I would like to use OLEDB as a connection type then I need to build a connection manager. So as I have already made the connection so I wanna use that one. So click on OK. In SQL query I would like to paste our insert statement. So I have already written the insert statement. So I would like to copy this and need to paste that query in our ssdt. So before going to paste this query into ssdt let's have a look of table. So it has 8 rows. So go to on ssdt and paste that query and click on OK. So here we need to create four variables. So first I would like to create four variables. This is for id and value should be integer and I would like to add id9. Second it should be name and it should be string value and what would be the value? Value would be John in third variable. This is for data birth and here we need to specify our date and I would like to use 2019 01 01 then in last variable this is for salary. So it should be integer and value would be 52000. So these are the values in our variables. So I would like to use these variables to map with our question mark. So go to on parameter mapping and here I would like to add four parameters and this is for id. So we can select our id. Second we need to select for name then we need to select for date of birth and last we need to select for salary and directions would be input then what would be the output data type. So for id it should be numeric data type then for name it should be where care then this is for date. So we need to select date then for salary again we need to select numeric and what would be the parameter name. So this is our first parameter so we need to specify zero. So one then two then three it will start from left side. So our first parameter would be id then name data birth and salary. So we have done our mapping now we can click on OK and we can save our package and click on start. So package executed successfully we can stop this package go to on SSMS and we can press control R. So as we can see id9 has been inserted successfully. If I want to update our name for id2 and we want to update with sucing then how we can update by using execute SQL task. So this is our update statement which I have written so we can copy and go to on SSGT double click on this execute SQL task and instead of this SQL statement I would like to paste our update statement. So here as we can see our name parameter comes first for name it would be zero for id it would be one. Now click on OK go to on parameter mapping and here I wish to remove our data birth and salary and here as we can see this is id and this is name. So put one for the id and zero for the name now click on OK. Now we can save it go to on variables and here I wish to change the values. So I want to change with sucing and id would be two. Now we can save it and execute our package. So package executed successfully now go to on SSMS and in this table I need to press control R so as you can see id2's name has been updated. So here I have created a simple store procedure. So in this store procedure it accept a parameter with id and it would return the id name and data birth. So I would like to create this store procedure. So store procedure created successfully. Now if I execute this store procedure for id1 then it should return information of id1. So we are getting id name and data birth. I can press question mark copy this execute statement and go to on execute SQL task and stop this package. Now click on this and here I can paste and it accept id now click on OK go to on parameters. So I have removed name then we need to add two real sets. So first for the zero then one and we are getting two as well. So first is id so I would like to for id. Then we are getting name then we are getting data birth. So now I need to click on OK. So by using script task we can check our output. So I would like to drag and drop script task and connect with execute SQL task. Double click on this script task read only variables I need to select our data birth and second name now click on OK. So go to on edit script here I need to use message box dot so dts dot variables and here we need to specify variable name that is data birth then dot value then dot to string. So this is for data birth second we want to use for name so we can specify name. Now we can save it and close it click on OK. So we have done our package now I wish to execute our package. So as we can see this is the data birth and this is the name. Now I am going to stop this package and go to on variables I need to change the id. So we want to output for id3 stop this go to on ssms. So here as we can see for id3 we are getting people so in our output we should get people we can execute our package and this is data birth and this is people so we are getting as we were expected. So thank you so much for watching this video if you like this video please subscribe our channel to get many more videos don't forget to press the bell icon to get the notification of our newly uploaded videos thank you so much.