Unpivot Error in SSIS
I am getting the following error when trying to run the unpivot transformation in SSIS: Error: 0xC02020A6 at Data Flow Task, Unpivot [1933]: Incorrect UnPivot metadata. In an UnPivot transform, all input columns with a PivotKeyValue that is set, and are pointing to the same DestinationColumn, must have metadata that exactly matches the DestinationColumn. I am not sure why I am getting this error......any suggestions? Thanks
November 28th, 2012 2:06pm

Do you have incompatible datatypes in the columns? Do you have numbers in some of the columns that you are unpivoting and non-numeric strings in others?Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2012 2:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics