Category Archives: MSBI

Using variables in SSIS packages

Using variables in SSIS packages Passing variables at Runtime – SSIS Requirement: We have got a request to design a package which needs to be take care of the below functionality. 1.  Every day we get data from a client. … Continue reading

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

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