Category Archives: SSIS Issues and Resolution

Aggregate Transformation: Aggregate transformation is used for basic aggregation as in SQL such as count distinct, group by.  Advance Window Providing the number of distinct values, exact or approximate, optimizes performance, because the transformation can preallocate an appropriate amount of … Continue reading →

Reading Data from XML Source Adapter XML source adapter does not support mixed content model on complex types. I was getting the above error while try to read my XML file from XML source adapter in data flow task. I … Continue reading →

Issue while reading data from XML Error Message [XML Source [1]] Error: The “component “XML Source” (1)” failed because truncation occurred, and the truncation row disposition on “output column “Query” (7382)” specifies failure on truncation. A truncation error occurred on … Continue reading →

Issue in reading object variable in Script Task in for loop in SSIS. While working with SSIS object variable I have faced some issue when I used it in loop and not able to get any proper solution on web. … Continue reading →