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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2010-05-25 : 16:47:27
|
| Can anyone give me an idea on how i can loop though a table, and export one text file for each product in a file.this is going to be a script that runs nightly and i have to ship text files to our mail house by product every night.thanks!(Trying to use SSIS to do this.) |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-05-25 : 17:04:31
|
| Use one SQL Data source...and a conditional split to choose each product..and route each result to an appropriate flat file. |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-05-25 : 17:21:43
|
| didnt even think about a cond. split. thanks! only thing is i need it to be dynamic so we dont have to change the code if we add products in the future. also i dont want it to create a flat file if the resultset = 0 make sense? |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2010-05-25 : 17:24:01
|
| is there anyway to do like a foreach loop or something like that? |
|
|
|
|
|
|
SSIS Export text file for each product