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 |
|
subbu_mareedu
Starting Member
11 Posts |
 Posted - 2014-04-16 : 16:49:47
|
| Hai friends,i have 2 column which is fileName and Details. It will populate something like this:File Name detailsdocument1 hello this is document1document2 hello this is document2how can i split 2 different columns into two txt files using ssis?document1.txtdocument2.txtis it possible?RegardsSubbusubbu |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-17 : 08:25:29
|
| In your DataFlow, after the source component, insert a MultiCast transform. On one branch, write the file name to document1.txt (destination). On another branch, write the details to document2.txt (destination) |
 |
|
|
|
|
|
How to split two columns of into two destinations