Version 1.7 beta

Rating:        Based on 4 ratings
Reviewed:  4 reviews
Downloads: 11294
Released: Aug 20, 2014
Updated: Aug 28, 2014 by Tillmann
Dev status: Beta Help Icon


Application SSIS GoogleAnalytics Source 2012.msi
application, 1587K, uploaded Aug 20, 2014 - 3052 downloads
Application SSIS GoogleAnalytics Source 2014.msi
application, 1588K, uploaded Aug 20, 2014 - 2752 downloads
Source Code Dimension.xml
source code, 71K, uploaded Aug 20, 2014 - 1926 downloads
Source Code Metric.xml
source code, 56K, uploaded Aug 20, 2014 - 1766 downloads
Source Code SSIS Metadata Project
source code, 1407K, uploaded Aug 28, 2014 - 948 downloads
Application SSIS Metadata Project
application, 1409K, uploaded Aug 28, 2014 - 850 downloads

Release Notes

  • Update for SQL Server 2014
  • Integration of file Connection Manager for dimensions and metrics
  • Elimination of the embedded resources (dimension/metrics)
  • Preparation for the use of Exceptionless
  • Various bug fixes
  • SSIS package to create the dimensions and metrics files (currently only for SQL Server 2012)

Reviews for this release

There are some issues with this release, but I think the developer has abandoned this component. Since the dev has not updated the source code, the community cannot resume development of this component. Seems antithetical to the idea of open source projects.
by iamOzymandias on Apr 29, 2016 at 2:29 PM
In theory, this would be a great tool, but it has some odd quirks and errors that keep it from being incredibly useful. SSIS is a great tool for organizations looking to automate data flows - but this package seems to assume that the user will be running this on a desktop and logging in manually to Google Analytics. It's not really built for server-side deployment. On top of that, it just doesn't work for more advanced Google Analytics metrics. Most of the time-based metrics throw an error ("time on page", for example). Choosing to pull traffic for a user-defined segment gets the wrong data - whatever the problem is, we consistently see traffic for the wrong segment when we try to pull data for something other than "all traffic." Most Google Analytics users will probably be satisfied with what's in Google's web platform for Analytics. Those looking for more power, while theoretically served by this tool, are going to start scrutinizing it and find it falls short of the mark.
by robertsm on Mar 1, 2016 at 1:48 PM
I think with a bit of c# experience anyone can create the xml files using the supplied project and the designer works like a dream. As a regular user of MS Visual Data Tools I sometimes need my CLR handed on a plate to get a POC up and running. If it proves successful I can justify applying a bit more in the linear programming bit. This is really good if you are into a set-based mindset and like me it takes a little while to make a shift. Anything missing? Many businesses like my employers like to minimize web facing servers so to future proof this I would suggest the designer could include a Proxy. The Metadata project is fully customizable, but the designer task is too much for my meager skills to add proxy code. Overall this is an excellent deployment.
by ukfoz on May 2, 2015 at 6:13 PM
The documentation needs some work, but it didn't take much poking around to make it work. I'm very happy I didn't have to write a custom script to handle this so I appreciate this very much.
by efesar on Feb 9, 2015 at 6:16 PM