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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How to split two columns of into two destinations

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 details
document1 hello this is document1
document2 hello this is document2

how can i split 2 different columns into two txt files using ssis?

document1.txt
document2.txt

is it possible?

Regards
Subbu

subbu

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)
Go to Top of Page
   

- Advertisement -