Google GData Source

Overview

Data flow source, loading information from various Google services. To extract information from extension element use XPath Transformation script. The script has the following parameters:

• Service – specifies Google service.
• BaseUrl – specifies service base URL.
• IsUsernameVariable – indicates whether the username is stored in a variable.
  • Username – specifies Google service user name.
  • UsernameVariable – selects variable containing username.
• IsPasswordVariable – indicates whether the password is stored in a variable.
  • Password – specifies Google service password.
  • PasswordVariable – selects variable containing password.
• ProxyUrl – specifies proxy server URL.
• ProxyUser – specifies proxy user name.
• ProxyPassword – specifies proxy password.
• BatchSize – specifies number of rows to retrieve in a batch.
• IsQueryVariable – indicates whether the query is stored in a variable.
  • Query – specifies query parameters.
  • QueryVariable – selects variable containing query.

Requirements

Depends on CozyRoc Script Component Plus component for implementing parameters user interface.
Requires installation of CozyRoc SSIS+ 1.4 library.
Requires Google GData .NET Client 1.6 library.

Deployment of Google GData .NET Client

After you download Google.GData.Client.dll you have to:

• Deploy it in the Global Assembly Cache (GAC).
• For SQL 2005: copy the library to C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
• For SQL 2008: copy the library to C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies