Posted - 03/03/2013 : 12:46:24
| Hi All,
I am new to SSIS. I want to load multiple files to DB tables in following manner:
Suppose I have 3 files. 1. Employee_detail: This file has 3 columns -ID ,name,Dept_id 2. Department:This file has 2 columns -Dept_id,Dept_name 3. Salary:This file has 2 columns-ID,Salary
I want to load these three files into Three different DB tables: Emp_detail(1st file), Department (2nd file),Salary_table (3rd file).
Could someone please help me to do this.