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 |
|
ssisbeginner190
Starting Member
3 Posts |
 Posted - 2009-06-18 : 01:05:02
|
| Hi Experts :-)i have a requirement like this..1. I have to create multiple files out of a SSIS package.( i have done this).2. If a file does not have any data( empty file), then that need not be created in the directory at all..The second one is a strange requirement..could any one of you help me in this. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-06-18 : 11:50:11
|
| I can think of this...On the post execute event (after all the files including the empty files are created), you can have a script task to check if the file is empty and delete it from the directoryBut..maybe there is a better idea. |
 |
|
|
|
|
|
Need help on File handling..