Post reply

SSIS 2008 - Pivot transformation and DT_NText Datatype

  • August 24, 2012 at 3:55 am

    #265916

    Hi,

    Has anyone ever tried using a column with dt_ntext datatype in the pivot transformation for ssis 2008?

    I am trying to use it and it gives me the following error -

    Error at DFT - Load and Pivot DAta [Pivot[[40]]: The Input column "DataSubmitted" (2818) cannot be used as a Set Key, Pivot Key or Pivot Value because it contains long data.

    If i use DT_WSTR it works fine but I need to use Dt_Ntext as length of the incoming data is not defined and I need to scope that in my ssis package.

    Any help would be highly appreciated.. I am literally stuck here 🙁

    Thanks..

  • August 24, 2012 at 4:16 am

    #1529633

    sorry, i realised i posted this under the wrong forum topic. I've now posted it under business intelligence. Dont know if I can delete this post some how 😕

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply