What is the transaction support feature in SSIS and how to configure it?

transaction support feature SSIS
If a package fails in the middle then SSIS used this functionality to start the execution from the place where it failed. Also the transactions gets roll-backed aswell if needed.
Supported – Parent object has initiated a transaction and child package will participate in it this transaction
Required – This will create and start a new transaction
NotSupported – This will not support the transaction
We need to enable MS DTC (Microsoft Distributed Transaction Coordinator) Windows Service for transaction support

What is the transaction support feature in SSIS and how to configure it? was last modified: October 1st, 2017 by Justin Antony

Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.”

The issue can occur on the following reason.

  1. Any third party SSIS support installation is missing.
  2. SSIS Version compatibility issue.
Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.” was last modified: October 1st, 2017 by Justin Antony

32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server

msolap cannot be loaded
The issue occurs if you rebuild index sometimes due to registry corruption

For this issue you need to deregister and register the dll files again. This will basically overwrites the 32 bit dll with the 64 bit dll.

Deregister Steps:

regsvr32 /u “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 /u “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

Register Steps:

regsvr32 “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server was last modified: October 1st, 2017 by Justin Antony

What is Azure ?

Azure is a Microsoft public cloud computing service. This is a world wide network and providing services like Compute, Analytic, Storage, data management, Network and security. They can run the applications on the internet also providing the BI tools to explore. In Azure you can Build, Test and Deploy application. You can ensure your data safety in the Azure cloud network. The platform is mainly helpful for saving money and having High speed interface no matter where they are accessing. Advanced services like predictive analysis are integrated in the environment.
Using the BI Tool of SSIS we can import or export data to the Azure cloud service.

What is Azure ? was last modified: October 1st, 2017 by Justin Antony

Tabular Model in SSAS

Tabular Model SSAS

Tabular models are in-memory databases in Analysis Services. The xVelocity in-memory analytics engine (VertiPaq) delivers fast access to tabular model objects and data by reporting client applications such as Microsoft Excel and Microsoft Power View.

Tabular models support data access through two modes: Cached mode and DirectQuery mode.
In cached mode, you can integrate data from multiple sources including relational databases, data feeds, and flat text files.
In DirectQuery mode, you can bypass the in-memory model, allowing client applications to query data directly at the (SQL Server relational) source.

Tabular Model in SSAS was last modified: October 1st, 2017 by Justin Antony

Overall understanding of Datawarehouse Tools : SSIS, SSRS and SSAS ?

SSIS

This is an ETL Tool, ETL means EXTRACT, TRANSFORM and LOAD. you can extract the information from various source system like Oracle, MSEXCEL, SQL SERVER, MS ACCESS, DB2 etc.. All these data which we are extracting can undergo the cleaning process and making this data to information by doing some calculation and finally the Data will be pumped to the warehouse. The SSIS from Microsoft is playing a major role of ETL tool and it is helpful in the First Section of Warehouse Loading data.

SSAS

After pulling the Data to the warehouse you need to do Analytical operations and here comes the cube. You can go all the aggregate operations in this and you can prepare the cube in such a way that data is readily available for the reports.

SSRS

This is a reporting Tool and use to give the report output of the Datawarehouse or Database or SSAS to the customer. You can have Detail or graphical reports and very helpful for analyzing the results. We have KPI(Key performance indicator) reports.

Overall understanding of Datawarehouse Tools : SSIS, SSRS and SSAS ? was last modified: October 1st, 2017 by Justin Antony

What is an MSBI ?

MSBI

MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

What is an MSBI ? was last modified: October 1st, 2017 by Justin Antony