The TARGIT Google Analytics SSIS task was a project I was in charge of at TARGIT. The company discontinued the project. There will be no support or further releases of the task.
I recommend anyone using the TARGIT Google Analytics SSIS package find a new option. I have asked them to opensource it so that development can continue on the project but have not heard anything about that as of yet.
[wp_ad_camp_5]
Hello,
I recently installed the plug in for SSIS 2008. I can see “Targit” listed in the avaliable connection managers, but I am not seeing it as an option as a source in the Data Flow toolbox. Do I need to do anything else to get it to show up?
In the earlier versions of BIDS, the tasks must be added to the toolbox. Right click in the toolbox and, then “Choose Items…” and select the tasks in the “SSIS Data Flow Items” tab
I’m trying out these tools in SSIS for SQL2014. However, trying to create the connection manager already has me stumped. As soon as it tries to authenticate, it comes back with a MethodNotFound error (‘System.Collections.Generic.IEnumerator’1 Newtonsoft.Json.Linq.JArray.GetEnumerator()’
Any ideas?
What do you see when you click the “new” button? At what stage do you get that error message? Do you have an older version of the JSon library in GAC? “C:\Windows\assembly\Newtonsoft.Json” should be version 4.5.0.0
It’s me again. I just want to make sure that this happens to me after I clicked on “new” button then clicked on Accept. It’s after clicking on Accept that I got that “Error ShowAccounts: MethodNotFound error (‘System.Collections.Generic.IEnumerator’1 Newtonsoft.Json.Linq.JArray.GetEnumerator()” error like Christi.
I have the same problem and I do have the JSon version 4.5.0.0 in the GAC. Please help as soon as you can because I’m already weeks behind on this implementation.
Thanks,
Nguyen
Hi,
I am looking to bring in data specific to a segment. Could you please let me know if this is possible with the data reader.?
Thanks
We haven’t added segments to the Data Reader.
Is it possible to access Custom Dimensions and Metrics?
It depends upon how you want to access them. If you want to retrive the data stored in them then yes then can be found in the Custom Variables or Columns – Dimensions & Metrics Explorer if you want to manage them then you need to check Management API – Custom Dimensions and Metrics Developer Guide
Hi Linda,
can you explain how I can query custom metrics in “TARGIT Data Reader for Google Analytics”?
I found the check box with “Custom Metrics 1” but the name of my custom metrics are quite different.
I try to pass that metrics through the “Properties” windows but it not allows me to define the columns (I’ve also tried to specify the “columns” property value but the custom columns doesn’t appear as task output column).
Unfortunately i dont work for TARGIT anymore. Due to a few very strict clauses in my contract I am unable to assist or comment on this project. I suggest you try and contact them now, however they last i heard they were no longer going to be developing on this project so i doubt they will be offering support for it.
sorry i can not be of more help
Hi,
I tried to look for it but can’t find pricing information. How much would it be to use this? Also, per current company rules, we have to use .NET 4.0, does this support it or is there any way to support it?
Thanks,
Nguyen
TARGIT doesn’t charge for using the SSIS task but it is unsupported. Support comes when you buy TARGIT Google Analytics accelerator. Yes it supports .net framwrok 4.0
Hi Linda, I setup global variables StartDate and EndDate in my SSIS project and choose to use “”SSIS varables”.
However, there is nothing in “Start Date” and “End Date” comboboxes to select from and whatever variable’s names I typed it does not except. I did not find anything in property and in Advanced Editor to configure in order to force component to accept my variables. We are using SQL Server 2014 version. Please advise. Thank you
Make sure the variables are type date or datetime. The drop down will only list date variables.
HI
i can not use Filters
how can it
The ssis task doesn’t support filters at this time. We just download the data you can filter it once its in the database.
It seems like ga:visits and ga:NewVisits are missing from the list?
Is there a reason for this or a way to update the list using an Expression in SSIS?
Please let me know.
Thanks
Those metrics where renamed April 16, 2014
Metric – ga:visits – Use ga:sessions instead.
Metric – ga:newVisits – Use ga:newUsers instead.
Hi Linda,
The TARGIT Data Reader for Google Analytics is exactly what I’ve been looking for to get our Google Analytics data into SQL Server for further analysis and reporting. I downloaded and installed in on my Windows 7 laptop with SQL Server 2005, set up the SSIS package in BIDS, created and new DB and table in our team’s SQL Server instance (hosted on Windows Server 2008 R2), tested the package, and it works great.
However, when I installed TARGIT Data Reader for Google Analytics on the Windows Server 2008 R2 DB server, it shows as being installed properly, but it’s not working properly within BIDS on that server. Initially I found that the 4 DLL files did not get copied to the PipelineComponents folder within SQL Server, so I copied them there from the DLLs in that folder on my laptop. That allowed me to add the TARGIT Data Reader for Google Analytics Data Flow item to the list of Toolbox Items within BIDS on the server.
Unfortunately, when trying to add the TARGIT Data Reader for Google Analytics Data Flow Source to the Data Flow Task stating that the “The component could not be added to the Data Flow task. Please verify that this component is properly installed.”. I restarted SSIS, and this error seemed to go away, but now I’m getting an error when trying to create the Connection Manager after double clicking on the TARGIT Data Reader for Google Analytics Data Flow Source. The error message states that the connection manager ‘TARGIT – Google Analytics’ is not properly installed. There is also an “Index out of range…” message on the dialog window.
I’ve uninstalled, reinstalled, repaired, run the MSI from an Admin command prompt, run the MSI as Administrator (after modifying the registry), and while I’ve made some progress, I just can’t get this to work on the server. If I knew what the installer did, perhaps I could figure this out, but during install a Command Prompt window appears for less than a second and then vanishes, so I’m not sure what it’s doing.
Any help you can provide getting this installed on my Windows Server 2008 R2 SQL Server 2005 instance is greatly appreciated.
Thanks,
Dean
Update…
I set up a new Windows Server 2008 R2 VM and installed SQL Server 2008 R2 SP3 on it. When I installed TARGIT SSIS For Google Analytics 2008, it’s not showing up in the Data Flow Items tab on the Choose Toolbox Items dialog window. Again, this is due to the 4 DLL files not getting copied to the PipelineComponents folder. Something with the MSI installer doesn’t seem to be working properly on the servers.
Please help.
Thanks,
Dean
I figured out the issue with the TARGIT SSIS For Google Analytics installer. It assumes that SQL Server is installed in the default directory. However, my SQL Server instances are not installed in the default directory. They are installed in a D: partition for the SQL 2005 server and an E: partition for the SQL 2008 R2 server. I created the DTS\Connections and DTS\PipelineComponents folders within the default SQL Server directory structure, and all of the DLL files were copied during installation to those folders, after which I copied them to the corresponding folders within my actual SQL Server installations on the D: and E: partitions. If you could update the installer to copy the DLLs to the actual SQL Server installation folders, that would be great. Thanks
Hi,
I use SQL Server 2012 BI Edition and I have installed TARGITSSISForGoogleAnalytics2012 but
I have no TARGIT Data Reader for Google Analytics in my SSIS-Toolbox and no TARGIT for Google
Analytics – SSIS Connection Manager. Yet I have refreshed the SSIS-Toolbox and restarted Integration
Services. Is there really a problem when SQL Server is not installed in the default path?
Kind regards
Alex
I downloaded the GA SSIS SQL Server 2016 Edition but when I open a project in Visual Studio 2015 community edition and add a data flow task I dont see TARGIT Data Reader for Google Analytics.
Any ideas what might be wrong ?
The Visual Studio is running on an Azure VM. Could this be the problem?
When I put GA SSIS SQL Server 2016 Edition on a laptop and use Visual Studio 2015 community edition I see the
TARGIT Data Reader for Google Analytics.
When I create a new SSIS project in VS2015 in the Azure VM I see the TARGIT DAta reader.
It’s just for existing projects that it can’t be seen.
It shouldn’t be you can create a new project with the data reader if you like.
Azure VMs can be tricky, it shouldn’t be an issue. However when you installed the task i wonder if it has copied all of the files to the required locations. If you give me the exact specs of your VM I can do a bit of research see if i can find any problems.
It’s a Standard DS11 v2 (2 cores, 14 GB memory) VM with a 1 TB disk.
Do you need to know the location of any specific files ?
Did you install the SSIS task directly or are you installing TARGIT Google Analytics BIA?
Hi!
Is it possible to run package with Targit connection on SQL Agenta as a scheduled job. I am trying to set this up, but when I upload package to SSIS package store, Targits connection manager for GA is missing in package.
I tried to run it form command line, and have the same problem with error message as follows:
“Description: The connection type “TARGIT – Google Analytics” specified for connection manager “Connect for Google Analytics” is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
End Error”
Many thanks for your help and best regards!
Slavko
Hi.
I am also having a problem installing the SQL 2016 TARGIT SSIS data reader.
It installs cleanly but the component does not appear in the SSIS toolbox.
We also have a non-default installation – its installed on the D:\ drive.
Can anyone help?
See if this helps TARGIT SSIS data reader not appearing in tool box
Hi
I have installed Targit Data Reader for Google Analytics 2016 to the Windows 2012 server. I could see it in the toolbox in Visual Studio 2015. However, when dragging and dropping the Targit data reader into a data flow, VS gave me the following error. The error does not occur in the dev box which is Windows 10. What should be an issue?
Thanks.
Pham
===================================
The component could not be added to the Data Flow task.
Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. (Microsoft Visual Studio)
===================================
Error at Load data from Google Analytics to SQL [SSIS.Pipeline]: Component , clsid {4F885D04-B578-47B7-94A0-DE9C7DA25EE2} failed to initialize due to error 0x80131600 “”.
Error at Load data from Google Analytics to SQL [ [71]]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is “”.
===================================
Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)
——————————
Program Location:
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()
at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewComponent(String clsid, Boolean throwOnError, Boolean select)
Chan you check the about on your Visual studio Which version of Integration Servicesare you running?
Thanks Ms. Lawton. I found the issue. It was a missing of log4net. I have installed it and it’s working now. Thanks for your time.
Hi,
TARGIT is a good tool and something which I was looking for. But I am facing an issue with it. I am able to read the data from google analytics and store into a sql server table.
Now I am trying to automate the process on my machine by creating a batch file and inside batch file their will be a code to execute the package (dtexec.exe utility). but I am getting an error while doing so .
Error –
“Description: The connection type “TARGIT – Google Analytics” specified for connection manager “Connect for Google Analytics” is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
End Error”
Could someone please help me on this issue.
I think you should try and install it again. If it cant find the connection manager there is something wrong with your install. Unfortunately I cant be of more help as i dont work for the company anymore and due to a clause in my contract i am not allowed to consult on it anymore. I suggest you contact TARGIT
This was working fine for me, but today when i edit the connection manager, once I’ve been prompted with “Targit – Google Analytics would like to view your google analytics data”, I then select “Allow” and get a blank screen, if i click cancel i get the error: “Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index”
I’ve tried this on 3 separate machines now all with the same error, so perhaps something has changed at Google’s end?
I was the lead developer on this project when I worked at TARGIT. I stopped working for the company more then a year and a half ago as part of my contract I am not allowed to offer any support on it. As far as I know after I left no one took over the project and it has probably been left on the shelf somewhere to rot.
In recent months Google has made some extensive changes to their authentication system. These changes require that developers of applications request that their applications be approved by google before the authorization will work. Older application where allowed a grace period to fix their applications to support the new security measures. I suspect that no one at TARGIT has chosen to do this. If they have not i suspect the application is going to stop working.
I have tried to contact the company a number of times and ask them to opensource the project so that i can maintain it or to fix it themselves. I have never received a response from them since I left the company. I suggest you try and email “dennis at targit.com” see if he chooses to respond.