DSXchange

Hello,

I have a job that has a start and end loop acitivity and a bunch of steps being repeated n times. I need to create/overwrite an output file when the loop is executed the first time and then append to the same file for subsequent iterations of the loop. What are some of the possible ways of doing this?

Thanks.

Append will create the file if it doesn't exist. But that will also mean it will append to the previous run's file rather than replace it so you'll need an extra step. Before you get into your loop, ensure the file generated by the previous processing run has been deleted.

Thanks Craig.

I will implement your suggestion and update my post accordingly.

You can also have two identical output stages in your job, pass your counter value as a parameter to determine the start of the loop and have one stage create (Overwrite) the file and the other stage append to the file for subsequent runs by having proper constrains.