Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tndeepakbharadwaj
Starting Member
2 Posts |
 Posted - 2012-03-29 : 08:18:14
|
| 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
5072 Posts |
Posted - 2012-03-29 : 11:56:57
|
| Just create two destinations, drag 2 workflows from the source -- one to each destination. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-29 : 12:39:37
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-29 : 13:18:42
|
| ^^ Good point.My answer assumes you want both to get all of the source data. |
|
|
|
tndeepakbharadwaj
Starting Member
2 Posts |
Posted - 2012-04-03 : 09:08:23
|
| 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-04 : 20:02:50
|
| then use oledb source connected to multicast and take two ouputs. Link them to flat file and oledb destination.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Multiple destinations in SSIS with single source