The responses can be a number between 1 and 5. The values are their responses to each question. The 'email' column in the spreadsheet is the user's email address. Each column header represents a 'question_id' on the test. I don't have much control on how I get this data from a formatting/structure standpoint.īasically users are taking a test. I am looking to find out how I would design a package that would do this for me.
The excel file contains data that ultimately needs to be stored in multiple tables.
I am relatively new to SSIS and I have a recurring need to import an excel file into a SQL Server 2005 database.
