TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Pivot [28]]: Output column "TransMonth" (49) cannot be mapped to PivotKey input column.
Error at Data Flow Task [SSIS.Pipeline]: "component "Pivot" (28)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Resolution:
1. TransMonth column was added in the list of output columns. By removing this column from the output columns the issue was fixed.
Note: There can be many reasons for this error.
No comments:
Post a Comment