Dimension Page Truncate

Sep 7, 2015 at 8:49 AM
Edited Sep 7, 2015 at 8:50 AM
Hi all,
we are using the SSIS GoogleAnalyticsSource Task which is really helpful for us, but we are facing an issue. We are using the Version 1.7.0.0 and when we try to import the Dimension Page (ga:PagePath) its truncating the value to 255 characters. On the documentation it says that the datatype is DT_WSTR and the length is 4000 characters

We have set the truncate to False but it still truncates the value.

Regards,

Kostas
Jan 4, 2016 at 5:48 PM
Kostas,

Did you ever get this resolved? I'm having the same issue.

Thanks.

Kris
Jan 5, 2016 at 7:21 AM
Hi Kris,

we solved that by modifying the .xsd file. we changed the max value from 255 to 4000.

Hope that this helps.

Thanks,

Kostas
Jan 5, 2016 at 11:49 AM

It does – thank you. I modified the xml file and it works perfectly. I feel like an idiot. J

Thanks again – I appreciate that you took the time to respond.

Kris Brady