Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
preetpalkapoor
Starting Member
6 Posts |
 Posted - 2013-03-03 : 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,SalaryI 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.Thanks,PreetpalPreetpal kapoor |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-03 : 22:32:53
|
| you need to use three different data flow tasks for this. use flat file or excel source depending on whether its a text or excel file. then use oledb destination to transfer data to your sql tables. Define connection managers to connect to tables and files.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
load multiple files to multiple DB tables