Solved

SSIS Data Flow question

Posted on 2014-02-07
2
334 Views
Last Modified: 2016-02-10
I am new to SSIS so I need some help on most basic things. I am creating a package that transfers data from one source to another and there are two tables in a source db and two corresponding tables in the target db. I added one source and one destination to my Data Flow task but each one only allows me to choose one table. My question is - do I add another data flow task for the second table or do I add one more set of source-destination controls from the toolbox?

How is it normally done when transferring data from multiple tables/views with SSIS?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39842146
You have need not add another data flow task..

but you have to make another source and destination tables ( each of them have a different names)...

You can put them in the same task or different one.
0
 
LVL 35

Author Closing Comment

by:YZlat
ID: 39847607
Thanks!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

739 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