Calendar list recurrence data

Sep 14, 2011 at 6:30 PM

Is there a way to retrieve the RecurrenceData field from a Calendar list Event  using the Source adapter?

Coordinator
Sep 15, 2011 at 7:10 AM

Try pulling all of the columns and dump it to a SQL Table and look over the data to see if you can find what you're looking for.

Sep 15, 2011 at 1:14 PM
Edited Sep 15, 2011 at 1:17 PM

No, it's not there. I used a Data Viewer in SSIS to try and find it.
It's a hidden field so I guess it's not accessible by the adapter. Is that correct?

Coordinator
Sep 27, 2011 at 1:52 PM

The adapter in ssis will not return hidden fields, you can add a feature req for this.

Sep 27, 2011 at 2:14 PM

Done

Coordinator
Oct 6, 2011 at 5:02 PM

I plan to only include this on the source, i'm not sure hidden fields are updatable to even bother with it on the destination.

Oct 6, 2011 at 5:22 PM

Great! That works for me. We had to resort to a redesign this time, but it will be nice to be able to make use of this information next time.

Coordinator
Oct 6, 2011 at 5:28 PM

I just added a 'beta' version (fixes duplicate field names as well). try it out and let me know.

Oct 6, 2011 at 5:31 PM

I won't be able to get to this immediately. About to leave on a trip. I'll try to remember when I get back