Power BI

SSIS Expressions

Parameterized Connection Precedence Constraint Expression Execute SQL Task Expression Parameterized Connection I want to create a...

Connecting to Integration Services Access is Denied in SQL Server

Marek Vavrovic

Apr 9, 20221 min read

SQL

Connecting to Integration Services Access is Denied in SQL Server

Connection to the Integration Services service on the computer " XXX " failed with the following error: "Access is denied" By default...

HuffnerTextile - SSIS Initial data load.

Marek Vavrovic

Mar 30, 20224 min read

BI Solutions

HuffnerTextile - SSIS Initial data load.

Examples of BI joins -Dimensions DimEmployee Select [EmployeeID] [EmployeeKey], case when [EmployeeID] = 2 then 1 when [EmployeeID] in...

Marek Vavrovic

Oct 25, 202111 min read

SSIS - Incremental Load

Data source: http://www.planecrashinfo.com/database.htm. This is an article describing how I have been extracting data from that data...

Marek Vavrovic

Aug 25, 20213 min read

Merge Join Transformation in SSIS

The Merge Join Transformation in SSIS is used to perform SQL Joins such as Inner Join, Left Outer Join, Full Outer Join and Right Outer...

Union All vs Merge Transformation in SSIS

Marek Vavrovic

Aug 24, 20212 min read

Union All vs Merge Transformation in SSIS

Main differences: Union All Merge Sorted input: not requires requires Number of inputs: unlimited only two Sorted...

Marek Vavrovic

Aug 24, 20211 min read

Derived Column Transformation in SSIS

We can create the required expression using those built-in functions, Columns, Operators, and variables. SSIS Derived Column...

An overview of the LOOKUP TRANSFORMATION in SSIS

Marek Vavrovic

Aug 23, 20213 min read

An overview of the LOOKUP TRANSFORMATION in SSIS

Case Sensitivity in Lookup Transformation: Lookup in SSIS is Case-Sensitive, Kana-sensitive, Accent-Sensitive. Lookup Transformation...

Using Slowly Changing Dimension for incremental load in SSIS

Marek Vavrovic

Aug 21, 20212 min read

Using Slowly Changing Dimension for incremental load in SSIS

There are three types of SCD: Type 1 Fixed attribute. (can return error, if is updated) Type 2 Changing attribute. (overwrites an old...

Marek Vavrovic

Aug 20, 20211 min read

SQL Server and SSIS Data Types

Following table list the data type mapping between SQL Server data type and SSIS data type: SQL Server Data Type SSIS Data Type...

Marek Vavrovic

Aug 19, 20214 min read

Deploy package to SSIS Catalog

There a two types of deployment Project deployment model> deploying multiple packages Package deployment model> deploying single package...

Marek Vavrovic

Aug 16, 20213 min read

Foreach Loop Container in SSIS

https://docs.microsoft.com/en-us/sql/integration-services/control-flow/foreach-loop-container?view=sql-server-ver15 Content Exercise 1: ...

Marek Vavrovic

Aug 15, 20213 min read

For Loop Container in SSIS

The For Loop container defines a repeating control flow in a package. The loop implementation is similar to the For looping structure in...

Marek Vavrovic

Aug 15, 20214 min read

Execute SQL Task in SSIS

Example 1: Execute SQL Task, Result set: Sigle row, using dynamic query Example 2: Execute SQL Task, Result set: Full result set Example...

Marek Vavrovic

Aug 14, 20212 min read

Sequence Container in SSIS

It's used to grouping logically related tasks together which makes it simple to divide the control flow in a package into groups of tasks...

Marek Vavrovic

Aug 13, 20212 min read

File System Task in SSIS

The File System task performs operations on files and directories in the file system. For example, by using the File System task, a...

Power BI

SSIS

Import .CSV files from web site

Data Refresh - Expression.Error column not found

Covid-19 Dashboard

AdventureWorksDW2017 Dashboard

Wide World Importers Dashboard

Slovakia covid-19

DAX measures for Covid-19

Tesla 2009-2020 Financial reports analysis

Covid 19 Dashboard (OWID)

Huffner Textile Dashboard

Northwind dashboard

File System Task

Sequence Container

Execute SQL Task

For Loop Container

Foreach Loop Container

Project Deployment Model

Slowly Changing Dimensions

Lookup Transformation

Derived Column

Union All vs Merge Transformation

Merge Join

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

Power BI

SSRS

DAX

Data Source , Data Set in SSRS

Tabular Report with Wizard

Grouped Report with Subtotals

Grouped Report with Drilldown

List: Group on Page

List: writing a letter

Headers on Each Page

Table rows on a single page

Running Total