I found that using the script task when using a web service to get data works the best. You will need to reference the web service from your script and use whatever web methods are provided.