I would like to create a mapping andworkflow, to load a list from a Sharepoint site into a SQL Server database. I am unsure as to what is the simplest way to accomplish this and was wondering if someone had any ideas. So far I have tried declaring a Web Services Consumer Transformation but do not seem to be defining it correctly as no rows are being returned. Are there any special considerations in configuring it that I may be missing?
I will greatly appreciate if someone could point me in the right direction.