Thanks Martin that appears to have done the trick please note that the documentation for the dataadapter needs updating to show that it should be placed in source as at the moment placing it in the settings for the dataadapter does not work but following the above does work
