Tags » SSIS

May 2016 Meeting


Beginning BI with Microsoft Tools

First we’ll take a look at OLAP versus OLTPĀ and then we’ll move into using Microsoft’s tools to implement beginner level business intelligence solutions. 18 more words


All about knowing MSBI

What do you mean by BI?

In simple words BI stands for Business Intelligence. It is a process of converting data in to useful information required for doing business, taking appropriate decision to make it move in positive direction which will fetch profits. 1,267 more words


SSIS / Data Tools compatibility between 2014 and 2012

Well, to be simple: there is no backwards compatibility when you create a package in SQL Server 2014 Data Tools (formerly SSIS/BIDS). 2014 files only run on 2014 servers. 122 more words


Merge Join Transmission in SSIS

In this article, I create a simple ETL package that join the data from two SQL tables using merge join transmission and finally loads the result into a SQL table.Merge Join is same as JOIN in t-sql, you can choose between different types of Inner join, Left outer join and Full outer join. 1,082 more words


SSISDB Deadlocks after SQL 2012 SP3 installation

After applying SP3 and applying the suggested scripts from kb2972285, to fix possible performance problems with the SSISDB database, we ran into a situation where concurrent package executions from the SSIS Project catalog gave deadlocks. 391 more words

Microsoft SQL Server

How SQL and Business Intelligence integrated

We will cover relation between SQL and Business Intelligence today. Enterprise may either use relational data warehouse or directly host their data to Server Analysis Service such as SSAS. 473 more words