Monthly Archives: May 2012

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