Blog Archives

How to install SSIS 2012, 2014, 2016 (SSDT-BI for Visual Studio)

Introduction In this blog post you will learn how to install SSIS addon SSIS PowerPack (30+ extra tasks/components) and also how to install SSIS client/server tools. There are various versions of SSIS (Microsoft SQL Server Integration Services) such as SSIS 2008, SSIS

Tagged with: , , , , , , , , , , ,
Posted in SSIS

Consume XML Web service in SSIS (REST API or SOAP)

Introduction Microsoft provides native XML Source adapter but most of users will find it totally unusable in many scenarios. In this post you will learn how to read data from XML files or consume XML web service in SSIS using

Tagged with: , , ,
Posted in SSIS

Reference Assembly in SSIS Script Task (.net Custom Assembly)

In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add

Tagged with: , ,
Posted in SSIS

Get File Column Count using SSIS C# Script Task

Sometimes you have changing schema in your flat file (Columns added or Removed) If you ever want to know how many columns you have in flat file then simply use below snippet and it will tell you column count. #region

Tagged with: , , ,
Posted in SSIS

How to use SSIS Data Viewer in DataFlow Task

SSIS Data Viewer - Debug Pipeline

In this post you will learn how to use SSIS Data Viewer to debug/troubleshoot SSIS DataFlow Pipeline issues at runtime. You can use SSIS Data Viewer any time you want to see what your data look like at given point

Tagged with: , ,
Posted in SSIS

How to use SSIS Derived Column Transform

SSIS Derived Column Transform Expression

What is SSIS Derived Column Transform SSIS Derived column transform is used to change existing columns coming from Source or add New Columns in the Pipeline Buffer. Note: For simplicity we have used Free DummyData Generator Source in this post

Tagged with: , ,
Posted in SSIS

Tutorial on SSRS report grouping, expand collapse, toggle visibility, nested groups

  Incase someone wants to learn how to create SSRS Groups which can expand collapse like below then check this video I embedded in this post. Highlight of this SSRS video tutorial– How to create SSRS Groups and nested SSRS Groups

Tagged with: , ,
Posted in Business Intelligence, SSRS

BI Vendor Comparison / Analysis for 2014 by gartner and InformationWeek

Compare BI Vendors for 2014

BI Vendor Comparison / Analysis by InformationWeek (2014 outlook) Looks like Microsoft is at the top spot for Planned BI Vendor list in 2014. This is the analysis done by InformationWeek however according to  Gartner BI Vendor Analysis Tableau getting top

Tagged with: ,
Posted in Business Intelligence

SSRS Deploy Error: rsAccessDenied : The permissions granted to user ‘MyDomain\User1′ are insufficient for performing this operation.

Getting SSRS Deploy Error - rsAccessedDenied - The permissions granted to user mydomain\myAccount are insufficient for performing this operation.

I just had really odd SSRS access denied error during report deploy and cannot figure out. Bing help me to locate some clue but it was buried somewhere under long forum post. So I decided to create blog to save

Tagged with: ,
Posted in Business Intelligence, SSRS

SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000

ssas-analysis-service

I was trying to deploy my AdventureWorksDW2012 Cube Sample  and got interesting error as below OLE DB error: OLE DB or ODBC error: Login failed for user ‘MYDOMAIN\MYSERVER$’.; 28000 If you receive above error most likely your SSAS Instance running

Tagged with: , ,
Posted in Business Intelligence, DBA, SSAS