Initialization of data source failed – When Opening PowerPivot Excel

data source Initialization failed
This error occurs due to Excel Version Compatibility. When a New Data Model is opened in an unsupported old Excel Version then it will throw out the “Initialization of data source failed” error.

Initialization of data source failed – When Opening PowerPivot Excel was last modified: October 6th, 2017 by Justin Antony

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

What is a SSIS breakpoint and how to configure it?

SSIS breakpoint
To troubleshoot an SSIS Package we use the breakpoints.
Right click on any task in control flow and then select Edit Breakpoint, This will display a Breakpoint window. choose when the execution to be paused(OnPreExecute, OnPostExecute, OnError events). This will be helpful to see the values of a variable at runtime using the output window.

What is a SSIS breakpoint and how to configure it? was last modified: October 1st, 2017 by Justin Antony

Define candidate key, composite key , alternate key ?.

candidate key composite key alternate key sql server
A candidate key is one that can identify each row of a table uniquely.
A candidate key becomes the primary key of the table.
A primary key formed by combining at least two or more columns is called composite key.
If a table has more than one candidate key then one become the primary key and the rest are called as alternate keys.

Define candidate key, composite key , alternate key ?. was last modified: October 1st, 2017 by Justin Antony