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