SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Multiple destinations in SSIS with single source		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tndeepakbharadwaj
Starting Member

India
2 Posts
Posted - 03/29/2012 :  08:18:14  Show Profile  Reply with Quote
Hi,

I am new to ETL tools. I need to create a flat file destination as well as an insert to table (OLEDB destination) from one single source (OLEDB source) in SSIS. Can anyone tell me how to do this in SSIS.

Regards,
Deepak

russell
Pyro-ma-ni-yak

USA
4967 Posts
Posted - 03/29/2012 :  11:56:57  Show Profile  Visit russell's Homepage  Reply with Quote
Just create two destinations, drag 2 workflows from the source -- one to each destination.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47084 Posts
Posted - 03/29/2012 :  12:39:37  Show Profile  Reply with Quote
do you want both destination to get all data from source? or is there a logic based on which population has to occur?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4967 Posts
Posted - 03/29/2012 :  13:18:42  Show Profile  Visit russell's Homepage  Reply with Quote
^^ Good point.

My answer assumes you want both to get all of the source data.
Go to Top of Page

tndeepakbharadwaj
Starting Member

India
2 Posts
Posted - 04/03/2012 :  09:08:23  Show Profile  Reply with Quote
Yes, I need the entire source data to be passed to two different destiations like one destination to a flat file and another destination to an existing table
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47084 Posts
Posted - 04/04/2012 :  20:02:50  Show Profile  Reply with Quote
then use oledb source connected to multicast and take two ouputs. Link them to flat file and oledb destination.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000