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

[Senthil Palaniswami]

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.

 

[Senthil Palaniswami]

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 ...

[Anash P. Oommen (AdWords API Team)]

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.

[Senthil Palaniswami]

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.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@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.

For more options, visit https://groups.google.com/d/optout.

[Anash P. Oommen (AdWords API Team)]

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.

adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.

Visit this group at http://groups.google.com/group/adwords-api.

[Anash P. Oommen (AdWords API Team)]

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.

[ephilipse]

I just wanted to say that there way to solve this.

You can also do like this:

DfpUser user = new DfpUser();
DfpAppConfig config = (DfpAppConfig)user.Config;

config.EnableSoapExtension = false;

This effectively disables the soaplistener extension. This worked for me. In the entire part you can also add things like

config.OAuth2Mode = Google.Api.Ads.Common.Lib.OAuth2Flow.SERVICE_ACCOUNT;

config.OAuth2SecretsJsonPath ="<json secret file>";

config.NetworkCode = "<Your network code>";

[Senthil Palaniswami]

thanks ...

--

--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.

Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/8f6395b4-5f35-4fda-a2e8-0278a91a12a1%40googlegroups.com.