ssis webservice and certificate

Question

ssis webservice and certificate

keywestfl9

SSCertifiable

Points: 5215
More actions
June 29, 2009 at 1:17 pm

#133886

i am trying to use webservice task in my ssis package.
the webservice i am accessing need an certificate.
how do i do i thru Webservice task in ssis? Please let me know.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

keywestfl9 (6/29/2009)
i am trying to use webservice task in my ssis package.
the webservice i am accessing need an certificate.
how do i do i thru Webservice task in ssis? Please let me know.

The Web service Task uses HTTP Connection Manager for communication. You can specify your client certificate in the HTTP Connection Manager.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 2

Thanks a lot.

i think i can't use web service task as i have pass parameter and i dont think web service accepts parameter from table.

if i have to do thru script task how do i do it? Please let me know

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

keywestfl9 (6/30/2009)
Thanks a lot.
i think i can't use web service task as i have pass parameter and i dont think web service accepts parameter from table.
if i have to do thru script task how do i do it? Please let me know

Web service task supports parameters. Check the documentation.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 4

Thanks for the documentation.

Can you please tell me if i have to do the input parameter from a table column value, how do i do it?

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

keywestfl9 (7/1/2009)
Thanks for the documentation.
Can you please tell me if i have to do the input parameter from a table column value, how do i do it?

You have to load the column value in a package variable and then you can set the variable as input to the web service method.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 6

i created an execute sql task and taking the particular column i need and storing it to a package variable(user::people) 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

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

keywestfl9 (7/8/2009)
i created an execute sql task and taking the particular column i need and storing it to a package variable(user::people) 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

What you are doing is incorrect. The variable mapping is for passing parameters to the SQL statement you are executing. You have to store the column in the result set's variable. You should not use for each loop container. Your next step should be the web service task, passing the variable you used in the Execute SQL Task result set.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 8

Thanks for the help.

i created an variable in package level with datatype as object

created an execute sql task

resultset as fullresulset , connection and the sql statement

in the resultset : Resultsetname = 0 and the variable name as user::resultset

then i connected to webservice task

i did the http connection, wsdl download

in input task screen -- i selected service, method nothing showed up in webmethoddocumentation

i see two parameters and i tried entering the user::resultset under the value column and i get an exception and not the data.

Can you please tell me what i am doing wrong?

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 9

Thanks for the help.

i created an variable in package level with datatype as object

created an execute sql task

resultset as fullresulset , connection and the sql statement

in the resultset : Resultsetname = 0 and the variable name as user::resultset

then i connected to webservice task

i did the http connection, wsdl download

in input task screen -- i selected service, method nothing showed up in webmethoddocumentation

i see two parameters and i tried entering the user::resultset for one under the value column and the other parameter i can hardcode and i get an exception and not the data.

Can you please tell me what i am doing wrong?

COZYROC One Orange Chip Points: 28499 More actions · Answer 10

Find out what is the specific type of the method parameter you want to fill-in . Then use variable type, closer to what is expected. You are trying to pass parameter of type object, which is too generic.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

parthach Grasshopper Points: 13 More actions · Answer 11

You can do all the tasks by using ssis script task. You can write C# code inside the script task and pass the credentials for the certificate.