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[]: 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