Have you been trying to access Google Drive with C#? Do you need to upload files to Google Drive with .net? In this post, we will be looking into accessing Google Drive using OAuth2 with C# using the Google .net client library. You can change the scope easily to […]
In this SSIS tutorial i will be showing you how to work with Data flow Tasks. We will be loading a text file into the database. We will be working with Flat file and Ole DB connection managers both at the package level and the project level. […]
Role playing dimensions in SSAS are very useful. Lets say you have a fact table with LandingPagePathId, ExitPagePathId, PagePathId. Now in your database you only need to have one dimension table dPath. All your paths are then stored in the same table. We only need to have one […]
Google Analytic’s Annotations allow users to leave little notes attached to specific dates. These notes are then display attached to that date in your report graphics in Google Analytic’s. By double double clicking on any of the Circles in a graph you open the Create new Annotation section. […]
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 […]
