Hi All, I need to read the data from google analytics to load into sql server data base using ssis. I am sure there is way to do this but i am not sure how? Please let me know how to do this. Thanks in advance tinku

Well I'm kinda doing this as well atm, and am very confused myself. Right now there are two API's the old API and the new API. The new isn't ready yet but does all sorts of good things. I know thats not much help but I am a still not sure of anything with it myself. Here some links http://code.google.com/apis/dfp/docs/reference/v201004/ReportService.html http://www.google.com/support/forum/p/dfp/label?lid=1b9325797a56e7d2&hl=en

Hi Thanks for the quick reply. Can you please provide a sample how are doing it?

Check this script for ideas.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi All, I used Excellent Analytics to pull the data into excel and loaded into the DataBase. Its just a plug in in Excel. http://excellentanalytics.com/ Thanks a lot for your help.

I love your stuff from cozyroc