[wp_ad_camp_3] 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 […]
[wp_ad_camp_3] 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 […]
There are a lot of reasons to want to find the columns with nulls in your SQL Server Database. For me the main reason is that when processing a SQL Server Analysis Services cube with null values can cause some big problems. Are you also been trying […]
[wp_ad_camp_3] 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 […]
SQL Server Integration Services packages can be executed programmatic. In this tutorial I will be showing you how to do it with C#. I will also explain how to avoid the Error “The Execute method on the task returned error code 0x80131621″. Reference In your project you will need to […]
This short tutorial will explain just a few of the ways you can use variables in your SQL Server Integration Services packages. From time to time you may want to create a variable in your package that you can either change easily or can update automatically. Lets say that every […]
Google recently commissioned a Nielsen study to understand the role of mobile devices and the customers path to purchase. Nine hundred and fifty people participated in the study, they responded to a servery and there mobile usage was observed for 14 days. I found the results quite interesting […]
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 […]
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 […]
