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 |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2010-05-13 : 14:17:15
|
| I have the following in my SSIS package:Flat File SourceScript ComponentDerived Column (to convert the date)Multicast Next...one arrow from the multicast goes to the first sql destination Next...I have 16 derived columns extended from the multicastNext...Union AllNext...A second SQL destinationI want a specific field to go into the second destination but it's going into the first destination. How do I make a copy of it and make it go into both or just the second destination? The field is called HUN and it's 7 characters in the DB. |
|
|
|
|
|
Multicast question