Posts

Showing posts from June, 2010

SSIS - Google Spreadsheets Data Source

Image
Download Source Files: Here In this blog entry I’m going to show you how to access data from a Google spreadsheet in SSIS using the Google Data API. I’m really into  Google Spreadsheets, especially the newest release which allows for a lot of collaboration.  One of the great things about Google spreadsheets is the ability to create forms that you can Email to other or even embed in your blog. However for me there is one limitation, how to get your data out of those spreadsheets and into other applications.  Well in true Google fashion they’ve built an API that lets you access and manipulate Google Spreadsheets.  Installing the Google API Firstly you need to download and install the Google Data API SDK http://code.google.com/p/google-gdata/downloads/list Once downloaded, run the Google Data API Setup(1.4.0.2).msi, this will install the dll’s  in C:\Program Files\Google\Google Data API SDK\Redist you need to register the following dll’s in the GAC (C:\Windows\assembly). G