Tag Archives: Business Intelligence

SSIS Error Derived Column Failed because Truncation Occurred

SSIS Error Derived Column Failed because Truncation Occurred Error Message: SSIS Error Derived Column Failed because Truncation Occurred: This is an error occurred while executing a SSIS package. The exact error message is “component “Derived Column” (20)” failed because truncation … Continue reading

Posted in MSBI, SSIS | Tagged , , , | 6 Comments

How to Configure SSRS 2008 R2

How to Configure SSRS 2008 R2 How to Configure SSRS 2008 R2 Introduction: This post helps you understanding how to configure SSRS 2008 R2 service. Installation is nothing much difficult, we can just choose SSRS in features list while installing … Continue reading

Posted in MSBI, SQL Server DBA, SSRS | Tagged , , , , , , , , , | Leave a comment

Real Time Example for SSIS Transformations

Real Time Example for SSIS Transformations Introduction: List of 28 Transformations are as follows S No Transformation Real Time Examples 1 Aggregate Summing / Averaging a total of the products purchased by a customer online to produce the final amount. … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , | Leave a comment