In this post I’m going to a basic lesson in SQL Server Integration Services, how to create a project, we will be focusing on the lay out of an SSIS project. The Control flow, Data Flow, we will be looking into tasks, source and destination adapters. What is SSIS? In […]
Have you ever wanted to request more than 7 dimensions from the Google Analytics API? Does this Limitation frustrate you? Are you looking for a work around to allow you to request more then 7 dimensions from the Google Analytics API. I have a work around that you […]
As you know there are two ways to connect to sql server. Windows Authentication SQL Server Authentication Windows Authentication uses the logon on your pc to access the database server. While SQL Server Authentication required that you enter a login and a password. The picture above shows what happened when I tried to […]
On several of the Google Analytic’s pages you will see something called Traffic Type. The values are something like this (Direct,Referral,Organic,Paid,Campaign). Now if you are exporting your data out of Google Analytic’s you may have noticed there is no “Traffic Type” Dimension that you can query out. […]
So I am the proud owner of a new PC here at work. YEAH! But when I tried to process my cube in Analysis Services I got this error. OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT SERVICE\MSOLAP$SQL2012’.; 42000. I know I have seen […]
Are you trying to connect to one of the Google APIs Using C#? Are you trying to do this in .net framework 3.5 – 2.0? In this post I will be showing you how to authenticate to Google API, as an example we will be email and google plus profile […]
