• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

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

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
Rawan Jambi
Asked:
Rawan Jambi
1 Solution
 
NazermohideeenCommented:
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

Become a Leader in Data Analytics

Gain the power to turn raw data into better business decisions and outcomes in your industry. Transform your career future by earning your MS in Data Analytics. WGU’s MSDA program curriculum features IT certifications from Oracle and SAS.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now