Author Archives: uday arumilli

SQL Server database mirroring with screenshots

   SQL Server Database Mirroring With Screenshots   Introduction: This post takes you through SQL Server Database Mirroring with screenshots in both the ways using T-SQL script and management studio. Also you will learn components involved in SQL Server database … Continue reading

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 14 Comments

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