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

Detect CPU Load by SQL query

Detect CPU Load

Select count(*), Scheduler_ID
from sys.dm_os_Workers A,
sys.dm_os_schedulers as B
Where A.Scheduler_Address = B.Scheduler_Address
And A.State = 'Runnable'
Order by 1 desc
SELECT SUM(Signal_Wait_Time_MS) as wt
FROM sys.dm_os_wait_status
Detect CPU Load by SQL query 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