C# and web services with SSIS

Question

Post reply

C# and web services with SSIS

tripower

SSCrazy

Points: 2035
More actions
September 21, 2010 at 7:45 am

#227036

Can you use custom C# assemblies with SSIS and if so how, and when calling web services with SSIS and are there any caveats?

Viewing 8 posts - 1 through 7 (of 7 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

1. Yes. An example: http://www.texastoo.com/post/Create-a-custom-assembly-in-SSIS.aspx

2. Yes. You can use the Web Service Task. (what's in a name?)

For all the rest, I refer you to the almighty Google.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

steveb. SSC-Forever Points: 46733 More actions · Answer 2

With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and include them as part of the script.

I have never had much luck with the SSIS component to call webservices, I generally find that it easier and more flexable to write my own methods to call the webservice in VSA script task

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

steveb. (9/21/2010)
With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and include them as part of the script.
I have never had much luck with the SSIS component to call webservices, I generally find that it easier and more flexable to write my own methods to call the webservice in VSA script task

Don't you need to add them to the GAC before 'including' (I presume you mean referencing) them?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Phil Parkin (9/21/2010)
steveb. (9/21/2010)
With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and include them as part of the script.
I have never had much luck with the SSIS component to call webservices, I generally find that it easier and more flexable to write my own methods to call the webservice in VSA script task
Don't you need to add them to the GAC before 'including' (I presume you mean referencing) them?

And possibly restarting the Integration Services service so that you can actually see and use them.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Phil Parkin (9/21/2010)
steveb. (9/21/2010)
With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and include them as part of the script.
I have never had much luck with the SSIS component to call webservices, I generally find that it easier and more flexable to write my own methods to call the webservice in VSA script task
Don't you need to add them to the GAC before 'including' (I presume you mean referencing) them?

Good point . thanks..

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 6

ab5sr

SSCarpal Tunnel

Points: 4056

October 27, 2010 at 9:45 am

#1242997

Yep you have to throw it in the GAC

Lee

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 7

Though Microsoft has a provided Web Service Task..I also has made a provision of ST/SC...the only limit is data staging designers imagination!!! 🙂

Raunak J