Answered by:
ssis - google analytics

Question
-
Hello,
How is it to use the google analytics with ssis so that I can save client's activities in our website into sql server database?
Where do I start from?
What are the main tasks required to use in ssis?
etc.?Thank you
Wednesday, April 20, 2016 2:03 PM
Answers
-
Hi arkiboys,
You would need to have to hit some Google API (URLs).
But SSIS is not user exposable and typically runs in an environment shielded from the Web.
So if a user hits your website and it has hooks to Google Analytics (you need to register for) you will see all the stats without doing any extra work, so SSIS is not needed. Google has it in form of reports. You can download the data to visualize but downloading with SSIS is possible I'd say.
- Proposed as answer by Eric__Zhang Thursday, April 21, 2016 1:43 AM
- Marked as answer by Eric__Zhang Saturday, April 30, 2016 7:13 AM
Wednesday, April 20, 2016 3:16 PM
All replies
-
Hi arkiboys,
You would need to have to hit some Google API (URLs).
But SSIS is not user exposable and typically runs in an environment shielded from the Web.
So if a user hits your website and it has hooks to Google Analytics (you need to register for) you will see all the stats without doing any extra work, so SSIS is not needed. Google has it in form of reports. You can download the data to visualize but downloading with SSIS is possible I'd say.
- Proposed as answer by Eric__Zhang Thursday, April 21, 2016 1:43 AM
- Marked as answer by Eric__Zhang Saturday, April 30, 2016 7:13 AM
Wednesday, April 20, 2016 3:16 PM -
Thank youSaturday, April 30, 2016 7:57 AM
-
Thank you
Heres an example using codeplex custom task to capture GA data in SSIS
http://www.codeproject.com/Tips/996491/Integrate-Google-Analytic-Data-to-Local-Database-u
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook PageSaturday, April 30, 2016 8:53 AM -
This is working fine while running from SSDT but after deploying <g class="gr_ gr_31 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="31" id="31">iam</g> getting following error.
Data Flow Task:Error: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BE8C48A3-155B-4810-BA5C-BDF68A659E9E}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease) at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.get_RuntimeConnectionCollection() at SSISComponents.GoogleAnalyticsSource.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
could you please help me
Tuesday, October 24, 2017 6:51 AM -
This is working fine while running from SSDT but after deploying <g class="gr_ gr_31 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="31" id="31">iam</g> getting following error.
Data Flow Task:Error: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BE8C48A3-155B-4810-BA5C-BDF68A659E9E}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease) at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.get_RuntimeConnectionCollection() at SSISComponents.GoogleAnalyticsSource.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
could you please help me
Which method are you using?
Are you using the one in link or are you using API calls in script task?
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook PageTuesday, October 24, 2017 6:59 AM -
I am using the one which is in the link
- Edited by Pradeep Chavali Tuesday, October 24, 2017 8:26 AM
Tuesday, October 24, 2017 7:22 AM