Pivot transform not executing

• vijay.sap1255

  Mr or Mrs. 500

  Points: 592

  More actions

  February 4, 2014 at 3:23 am

  #289194

  Hi Experts,

  Am facing problem when trying to execute Pivot transform in BIDS 2008.

  The error is : [Pivot [25]] Error: The pivot key value "Q1" is not valid.

  [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Pivot" (25) failed with error code 0xC0202090 while processing input "Pivot Default Input" (26). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

  I have defined the input and output columns correctly in pivot transform and mapped to target excel.

  It seems that every thing is correct but still while executing am getting the above error. Please suggest

  Thank you and Regards,

  VijayVanamala

• vijay.sap1255

  Mr or Mrs. 500

  Points: 592

  More actions

  February 4, 2014 at 4:49 am

  #1685789

  Hi all,

  It got executed..

  The problem is with pivotkeycolumn in output column which should be defined correctly.

  Check the column name and pivotkeycolumn properly. try to give the both names same and then execute.

  Thank you and Regards,

  Vijayvanamala