SSIS Script Task access to GA APIs

[Scott Councill]

OK, I'm a rookie when it comes to calling web services with .Net.  There got that out of the way :)  I am, however pretty good with SSIS and Script Tasks.  I would like to add a Web Reference to my project and call that reference in my script.  We have Proxy issues that prevent me from using GoogleAnalyticsSource to connect to the service and it is my understanding that the regular Web Service Task won't work either.

First, what is the URL I should use to create the Web Reference for the script?  I tried the standard https://www.google.com/analytics/feeds/data and it asks for my UserName/Password.  I put in my GA account login and it doesn't work.  I have turned on the Analytic API in the Google APIs Console and that didn't help.  I have read through a bunch of the online documents but still haven't found what I'm looking for.

Help?

Scott

[chris@shufflepoint]

Since it's not SOAP, you can instead create the URL on they fly
against a connection manager you setup beforehand. See for example

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/913c63b0-2761-4f84-94e1-3c2e3af29309

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/9238215f-529b-49d7-88ce-5d61ee959c22

Chris Harrington
ShufflePoint

On Dec 21, 2:57 pm, Scott Councill <scott.council...@gmail.com> wrote:
> OK, I'm a rookie when it comes to calling web services with .Net.  There
> got that out of the way :)  I am, however pretty good with SSIS and Script
> Tasks.  I would like to add a Web Reference to my project and call that
> reference in my script.  We have Proxy issues that prevent me from using
> GoogleAnalyticsSource to connect to the service and it is my understanding
> that the regular Web Service Task won't work either.
>
> First, what is the URL I should use to create the Web Reference for the

> script?  I tried the standardhttps://www.google.com/analytics/feeds/data