Channel 9 has a 45 minute video with Dave Campbell about SQL Server Data Services. maybe this video will answer some of the question you might have about SQL Server Data Services
Watch it here: http://channel9.msdn.com/ShowPost.aspx?PostID=388698#388698