Hi, Has anyonbe had an experience of adding a script task that references the Microsoft Translator API. There is an article here that give details on how to create an application in C#, but the article says to add a "service reference" to the project. There isn't an option to add a "service reference" to a script task - only a "Web Reference" http://www.dotnetcurry.com/ShowArticle.aspx?ID=357 Thanks Paul

Same thing. "Web" = "Web Service" = "Service" reference... Talk to me now on

Hi Todd, They are not the same thing. By applying a Web Reference, as opposed to a Service reference (Service Reference is not given as an option in SSIS Script Tasks), I get completely different Components in the Object Explorer when using the following address:- http://api.microsofttranslator.com/V2/Soap.svc The Article provided at the beginning of the thread instructs me to use the "LanguageService" Class that isn't available when using a Web Reference. Web Reference Service Reference Thanks Paul

What version of VS and SQL are you using? Talk to me now on

Hi Todd, I am using:- VS 2008 (version 9.0.30729.4462) SQL Server 2008 Standard Edition Thanks Paul

Hi paul, Please refer to the following links about using Reference in Script Task: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6640ee51-0a16-4e58-9583-16fbd7340e96/ Thanks, Eileen

Hi paul, Please refer to the following links about using Reference in Script Task: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6640ee51-0a16-4e58-9583-16fbd7340e96/ Thanks, Eileen

Thanks Eileen, Will take a look at these and get back with my findings. Paul

Hi Eileen, I followed the instructions in the first post - but still couldn't get the right classes to appear. However, I found a relatively cheap solution here :- http://bluessis.com/Index.aspx?PageId=WebServiceCallComponent Thanks Paul

Hi Eileen, I followed the instructions in the first post - but still couldn't get the right classes to appear. However, I found a relatively cheap solution here :- http://bluessis.com/Index.aspx?PageId=WebServiceCallComponent Thanks Paul