Solved

insert into multiple different tables in sql using SSIS

Posted on 2014-07-23
3
498 Views
Last Modified: 2016-02-11
is there any way that can help me in getting data from one source then insert them into two different tables (for example Customer and Order)? I am using OLE DB destination and it is inserting in one table only

any help
0
Comment
Question by:Rawan Jambi
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40214009
Sure.  In a Data Flow task have one source task, a conditional split  or multicast, and multiple destination task.
Or if you'd prefer multiple data flow tasks with the same source, but different destinations.

>I am using OLE DB destination and it is inserting in one table only
A single source or destination can be used for only one set of data.

Beyond that, you'll have to spell out exactly what your needs are, this question is too vague to be actionable.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40214022
btw looks like you have a duplicate question here.   Let us know if that is correct, and if so we'll delete the duplicate.
0
 

Author Comment

by:Rawan Jambi
ID: 40214176
Thank you that's answer my question
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question