Passing a variable of object type from ssis to webservice

Question

Hi

can we pass a variable of object type from ssis to webservice(I am using a web service task to communicate with the web service. This particular webservice has a webmethod with input type as object). The webservice is developed in dotnet. My idea is to pass this variable as an object.

Will SSIS suport sending of  a parameter of type object to a webservice?

I have seen web service task sending string variables to a web service.However I am not confident whether a variable of type OBJECT can be passed from an SSIS package (using web service task) to a web service..Any issues ???

Answer 1

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/455f92e4-e888-47ef-98ea-4f6a37b49738

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f8c53465-dfa7-4c55-86b1-839a0e8bb50a

Answer 2

well the two links looked promising but still I am not able to figure out the answer to my question. can anyone tell the concept a bit more clearly. I am a new to ssis....

Answer 3

Hi

can we pass a variable of object type from ssis to webservice(I am using a web service task to communicate with the web service. This particular webservice has a webmethod with input type as object). The webservice is developed in dotnet. My idea is to pass this variable as an object.

Will SSIS suport sending of  a parameter of type object to a webservice?

I have seen web service task sending string variables to a web service.However I am not confident whether a variable of type OBJECT can be passed from an SSIS package (using web service task) to a web service..Any issues ???

Find out what is meant by "object" in this method from whoever is the provider of this web service. You cannot just pass any object. The object should be able to serialize/deserialize over HTTP.

---

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