SSIS Data Flow question

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?
LVL 35
Who is Participating?
Surendra NathConnect With a Mentor Technology LeadCommented:
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.
YZlatAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.