MSBI

Checkpoints with containers in SSIS

In the previous post “Using checkpoints in an SSIS package“, we discussed how to configure an SSIS package in order to enable the checkpoints. Now, In this post “Checkpoints with containers in SSIS“, we are going learn how to configure a package to restart from the first task of the container in which it fails instead of

Checkpoints with containers in SSIS Read More »

Using checkpoints in an SSIS package

Checkpoints in SSIS In this post “Using checkpoints in an SSIS package”, we are going to learn how to configure checkpoints in an SSIS package. SQL Server integration services use checkpoints in order to avoid the re-execution of an SSIS package from the beginning in case the package fails during execution. Checkpoints can be extremely useful in

Using checkpoints in an SSIS package Read More »

Get error column name in Data Flow Task in SSIS

How to get error column name and error description in Data Flow Task in SSIS During execution of an SSIS package, when a bad row comes in the data flow task, the task gets failed. However, most of the components (source, transformation, and destination) in the data flow task exposes an error output path which can

Get error column name in Data Flow Task in SSIS Read More »

Dynamic SQL in OLEDB source component in SSIS

The metadata could not be determined because statement contains dynamic SQL When we use a batch of T-SQL statements which contains dynamic SQL or uses temporary tables inside, in an OLEDB source component placed in a Data Flow Task of a SSIS package, we get an error during column names extraction because the source component gets failed to fetch the metadata (columns and their data types)

Dynamic SQL in OLEDB source component in SSIS Read More »

Change chart type dynamically SSRS

Today, we are going to learn how we can change chart type dynamically depending on the selected value in the report parameter in SSRS (SQL Server Reporting Services) report. Report parameter has few predefined chart type as values in the report, and depending on the selected value in the parameter, chart renders in the report. We know

Change chart type dynamically SSRS Read More »

Role playing dimension

We have explored Junk dimension and Degenerate dimension in previous posts, now we are going to discuss Role playing dimension in this post. Lets start with the definition followed by an example. Role playing dimension A fact table keeps the facts of a business process. It is built of two types of columns: measure columns and dimension key columns. Measure are the quantitative business data

Role playing dimension Read More »