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.
18 freelancers are bidding on average $218 for this job
I have used SSIS since SQL 2000 ( DTS ) and i am a certified C# and database administrator . Please ask me before accepting the bid , cause i placed bids on other projects today and i work alone .
Hello !I am highly Expert in this field. I'll provide you satisfaction. So your time and money will be safe when you will award me project thanks. let's discuss more.