Does SSIS Pivot component support DateTime2 datatypes RRS feed

  • Question

  • I am using SSIS Pivot transformation with one of the input columns which is of data type datetime2 to Pivot Usage=0. That is just letting the column value through the Pivot transform.

    However I am getting the following exceptions when the package executes. I am able to get around this exception if I convert the datetime2 column to datetime. Any insights appreciated. Thanks

    [Pivot [34]] Warning: Not able to convert object

    [Pivot [34]] Error: Failure when trying to pivot the source records.

     [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Pivot" (34) failed with error code 0xC020208F while processing input "Pivot Default Input" (35). 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.
    Wednesday, May 12, 2010 12:54 AM


All replies