i created an execute sql task and taking the particular column i need and storing it to a package variable(user:eople) with datatype as object
Then i have a for each loop container in collection i select the above variable i selected and in variable mappings i created another variable (user::lastname) and index as 0 since i need the first column
Now when i put webservice task and use user::lastname as the input variable it throws an error saying there is no lastname and it shows user::lastname
Please let me know how to pass the user::lastname to the webservice task
Then i have a for each loop container in collection i select the above variable i selected and in variable mappings i created another variable (user::lastname) and index as 0 since i need the first column
Now when i put webservice task and use user::lastname as the input variable it throws an error saying there is no lastname and it shows user::lastname
Please let me know how to pass the user::lastname to the webservice task