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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 load multiple files to multiple DB tables

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,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.

Thanks,
Preetpal

Preetpal 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -