Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

insert into multiple different tables in sql using SSIS

Posted on 2014-07-23
3
Medium Priority
?
833 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 66

Accepted Solution

by:
Jim Horn earned 2000 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 66

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.
Suggested Courses

564 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