Solved

insert into multiple different tables in sql using SSIS

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

726 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