Hello

I am doing an assignment where we have to take multipl CSV files and import them into a SQL DB. To do so we are using SSIS in Microsoft Visual Studio. Here is the pic of the DB.

We have one CSV that has a Column named Instructor. I need to take the Column "instructor" and use a lookup task to pull the InstructorID from DimInstructor. But I cant.

That is because the Instructor column from the CSV is a string and the InstructorID in the DB is an Int. But I need to map them together for the lookup to work. What do I do?

DimCourse Column Name Data Type Allow Nulls DimSection Column Name Data Type Allow Nulls SectionCode Modality nvarchar(10) nvarchar(30) CourseTitle FactRegistration Column Name Data Type Allow Nulls Factld nvarchar(10) nvarchar(10) DimSemester Column Name Data Type Allow Nulls ActualEnrollment nchar(6) OriginalEnrollment Year Semester AcademicYcar DimInstructor nvarchar(10) Column Name Data Type Allow Nulls nvarchar(10) nvarchar(50) nvarchar(30) DimCourse Column Name Data Type Allow Nulls DimSection Column Name Data Type Allow Nulls SectionCode Modality nvarchar(10) nvarchar(30) CourseTitle FactRegistration Column Name Data Type Allow Nulls Factld nvarchar(10) nvarchar(10) DimSemester Column Name Data Type Allow Nulls ActualEnrollment nchar(6) OriginalEnrollment Year Semester AcademicYcar DimInstructor nvarchar(10) Column Name Data Type Allow Nulls nvarchar(10) nvarchar(50) nvarchar(30)