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: 259015 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: 245813 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?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Koen Verbeeck SSC Guru Points: 259015 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..