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.

Cheers, Ken

Færdigheder: .NET, ASP.NET, C# Programmering, Microsoft, SQL

Se mere: sharp base, ssis sql, sql ssis, sql server ssis, web data table extract, web api sql server, net survey programming, ssis xml task, database extract api, xml transform, ssis script task, net response xml, extract data sql server, pilot data, monkey happy, data transform, proof concept net, extract database data sql, sql server web api, web service create api, connect project concept net, sharp script, ssis xml, ssis package, survey xml

Om arbejdsgiveren:
( 0 bedømmelser ) Bangalore, India

Projekt-ID: #5987621