Need to import Survey data from Survey Analytics to SQL Server Data Warehouse

• gayatri.krishnan86

  SSC Veteran

  Points: 216

  More actions

  June 30, 2015 at 10:49 pm

  #302136

  Hi,

  I have a CSV file coming from Survey Analytics. I need to import the Survey data in data warehouse using SSIS. Below is the sample of Survey Data in CSV

  ResponseID Name Which flavour of Ice Cream would you prefer?

  Vanilla Strawberry Mango Guava Chocolate

  1 ABC Strawberry

  My Data Warehouse table structure is as follows:

  tblQuestions - QID, Question

  tblAnswers - AID, Answer

  tblResponses - ResponseID, QuestionID, AnswerID, Score

  How do I import this using Flat File Connection? I am really stuck not sure how do I do this?

  Thanks,

  Gayatri