Solved

insert into multiple different tables in sql using SSIS

Posted on 2014-07-23
3
424 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Bulk load data error 5 33
MS SQL Backup 24 70
Report Builder 9 30
Convert SP in a format for debugging 7 0
From time to time, for debugging and troubleshooting your flow at run time you’ll need to check if the variable has the correct value or not, there’re several ways to check for the value of the variables inside the flow, You can add Break Points, a …
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 combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now