I was using the SSIS Sharepoint List Adapter and ran into an issue with importing calculated columns and People columns. The import process was inserting USERID;#Username into my People column in the destination database table. It was also inserting datetime;#12/12/2013 into my date fields. I found a handy script component […]
SSIS transformation for Sharepoint List Adapter
