Load MOSS Survey Questions

Mar 30, 2009 at 10:05 PM
Hi,
My goal is simple, load in SSIS a MOSS list, in particular a Survey.
The Survey can be mapped normally as a table with a row for each User and a column for each Question, the name of column is the question itself !?
The default metadata exposed by the Task contains this structure but the column names are only a subset of the relative question.
To obtain a complete extraction of the list questions (eg. as the excel export in MOSS), how the source task must be configured?   
It's necessary a specific CAML query?
Thanks in advance
Paul
Apr 10, 2009 at 4:12 PM
Well, I haven't worked with this specifically, but I'm thinking if the columns are the questions, perhaps looking into using the UnPivot command of SSIS might help put that into fields for you.  I recently have been using it make 'columns' look like a single column with an 'answer' (or value).  It isn't just for aggregations and can work with data as you specify.