Solved

input data into multiple tables in sql from one source using in one package using SSIS

Posted on 2014-07-23
1
223 Views
Last Modified: 2016-02-24
Hello
I have around 10 tables in sql and I am trying to pull data from Google Analytics source and input them from this one source into two of my table (Account  and Group) in SQL server.
Any suggestion how can I do that ?

thank you
0
Comment
Question by:Rawan Jambi
1 Comment
 
LVL 4

Accepted Solution

by:
Nazermohideeen earned 500 total points
ID: 40214741
You need to use the MultiCast Transformation inside your dataflow. This will duplicate the source dataset to unlimited number of destinations with the same data.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

735 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