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)
 export to different file name

Author  Topic 

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2014-02-25 : 23:30:33
i have 2 column which is fileName and Details. It will populate something like this:

FileName details
document1 hello this is document1
document2 hello this is document2

how can i pump into 2 different txt file using ssis?
i manage to pump in with specific name but i would like to pump into folder with the name as in column1.

end result will have 2 file name in my folder:

document1.txt
document2.txt

is it possible?
   

- Advertisement -