I am very new to SSIS package and facing problem in that.Scenario
Suppose i have two tables Student and StudentDetails and both tables have RegistrationNumber column in flat file.
I want to import all flat file data in to Sql Server tables.How to import
When a Student record from a flat file get insert into Student table in SQL, one autogenerated StudentID get generate which will be identity column as well as primary in Student table and foreign key in StudentDetails table.Issue
Whenever one record from student flat file get insert in Student table in SQL, then corresponding student details should also get insert into StudentDetails with foreign key , which get generated by Student table.
My Question is how to get auto generated value of Student table through SSIS.
I am able to inner join on both table based on RegistrationNumber but i am not getting StudentID which is autogenerated in Student table.