Create an SSIS project for SQL SERVER that can do the following
1) Connect to Survey Monkey API (authenticated connection - so can't use XML Task in SSIS so might need some sort of .NET script)
2) Extract Survey Response Data (for a given survey ID). The Survey will have 40 questions with each question response being on a scale of 0-6
3) Data Transform from web service\xml into a SQL Sever Table
SSIS project needs to be able to be imported into our sql server database.
Happy to give more information if required.
this is just the base pilot\proof of concept for my task. I would like to be able to edit and change all the script\package etc. But there might be further work down the track.