Hi,
As far as I know the Google Adwards API is not a pluggable into SSIS item.
But you can develop your own. Every SSIS Task or Transformation is a wrapper.
However, web interactivity from within ETL is not advisable.
I suggest you create a webservice so you decouple it from SSIS but still be able to interact with it using the conventional, built-in SSIS components .
Arthur
MyBlog
Twitter