For anyone who faces this issue in the future: The fix was to install the assembly into the Global Assembly Cache, and then use the fully qualified assembly name in the App.config.
Cheers, Anash P. Oommen, AdWords API Advisor. On Monday, October 19, 2015 at 3:59:27 PM UTC-4, Anash P. Oommen (AdWords API Team) wrote: > > Hi Senthil, > > Where is Google.Ads.Common.dll located? It either has to be in the same > folder as sqlserver exe or in one of the locations pointed to by PATH > variable. If you choose to put this in GAC instead, then your App.config > path should contain the fully qualified assembly name for > Google.Ads.Common.dll in the App.config. > > Cheers, > Anash > > On Monday, October 19, 2015 at 3:52:44 PM UTC-4, Senthil Palaniswami wrote: >> >> thanks Anash. >> >> I have the below settings on the SSIS Config files (DtsDebugHost.exe, >> ISServerExec.exe, DTExec.exe & dtshost.exe), none of them work as >> expected. Please assist. >> >> *Config: * >> >> >> <?xml version="1.0" encoding="utf-8"?> >> >> <configuration> >> >> <startup> >> >> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> >> >> </startup> >> >> <system.web> >> >> <webServices> >> >> <soapExtensionTypes> >> >> <add type="Google.Api.Ads.Common.Lib.SoapListenerExtension, >> Google.Ads.Common" >> >> priority="1" group="0"/> >> >> </soapExtensionTypes> >> >> </webServices> >> >> </system.web> >> >> </configuration> >> >> >> >> >> *Error: * >> The SoapListenerExtension class is not loaded. The most possible cause >> for this error is that you haven't registered >> Google.Api.Ads.Common.Lib.SoapListenerExtension as a soap extension under >> configuration/system.web/webServices/soapExtensionTypes in your your >> App.config or Web.config. See the sample App.config for details on how to >> register soap extensions. >> >> On Mon, Oct 19, 2015 at 8:23 AM, Anash P. Oommen (AdWords API Team) < >> adwordsapiadvisor+an...@google.com> wrote: >> >>> Hi Senthil, >>> >>> When you add a reference to App.config, the binary it is referring to >>> (in this case, Google.Ads.Common.dll) should be in the path where it can be >>> loaded. The easiest fix would be to: >>> >>> - Install Google.Ads.Common and Google.AdWords assemblies into GAC using >>> gacutil command. (or copy it to the folder where SQL server binary resides) >>> - Modify the App.config of SQL server to add the necessary configuration >>> in it. http://www.sqlis.com/post/Where-is-my-appconfig-for-SSIS.aspx >>> has instructions on how to do that. >>> >>> Cheers >>> Anash P. Oommen, >>> AdWords API Advisor. >>> >>> On Monday, October 19, 2015 at 8:01:06 AM UTC-4, Senthil Palaniswami >>> wrote: >>>> >>>> Team, >>>> >>>> Anyone has the same problem ?? I am keep getting the same error after >>>> adding the SOAP config in the C# code. Please assist. Thx ... >>>> >>>> >>>> On Thursday, October 15, 2015 at 10:30:23 PM UTC-4, Senthil Palaniswami >>>> wrote: >>>> >>>>> I am using the API in SQL server SSIS Package in script task with C# >>>>> to get the data into SQL Server database. >>>>> >>>>> the same code is working good in C# Console application with >>>>> App.Config file, but it is not working in SSIS. Please assist. >>>>> >>>>> >>>>> The SoapListenerExtension class is not loaded. The most possible cause >>>>> for this error is that you haven't registered >>>>> Google.Api.Ads.Common.Lib.SoapListenerExtension as a soap extension under >>>>> configuration/system.web/webServices/soapExtensionTypes in your your >>>>> App.config or Web.config. See the sample App.config for details on how to >>>>> register soap extensions. >>>>> >>>>> >>>> -- >>> -- >>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >>> Also find us on our blog and Google+: >>> https://googleadsdeveloper.blogspot.com/ >>> https://plus.google.com/+GoogleAdsDevelopers/posts >>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >>> >>> You received this message because you are subscribed to the Google >>> Groups "AdWords API Forum" group. >>> To post to this group, send email to adwords-api@googlegroups.com >>> To unsubscribe from this group, send email to >>> adwords-api+unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/adwords-api?hl=en >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "AdWords API Forum" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/adwords-api/T1aUzUoLh9M/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> adwords-api+unsubscr...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/adwords-api. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/adwords-api/92a2b3a3-5a99-4b7a-84dd-73c792f7c8db%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/adwords-api/92a2b3a3-5a99-4b7a-84dd-73c792f7c8db%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/adc636be-91d4-41fc-a33b-7f5b3289a5f6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
