SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 load multiple files to multiple DB tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

preetpalkapoor
Starting Member

India
6 Posts

Posted - 03/03/2013 :  12:46:24  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/03/2013 :  22:32:53  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000