DTS and ASCII

I have a DTS package that pushes the contents of a table into an ascii fixed
width file for upload to our bank. I need to be able to ether stop the DTS
package if the ascii file exists (first choice) or set the data pump to
append the ascii file instead of overwritting it.
1) Does anyone know how I could check for the existance of a text file on
the server from within a dts package and stop the package if it exists?
2) Does anyone know how to change the a SQL-table-to-ascii transformation
so that it will append rather than overwrite an existing ascii file.
Can't think of any code or other info I should be attaching, but let me know
if there is something that I should be telling you.
Charlie1) One option is an Execute Process task against an executable that checks
for file. Have an On Success condition. Have not tried, but that is one
option.
2) Instead of append, rename and then create file two. You can merge them
later.
3) Consider something other than DTS, or creating a process that then fires
DTS run after it does the additional items on your list.
AFA code is concerned, you end up in multi-phase pumps.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Charlie Chisholm" wrote:

> I have a DTS package that pushes the contents of a table into an ascii fix
ed
> width file for upload to our bank. I need to be able to ether stop the D
TS
> package if the ascii file exists (first choice) or set the data pump to
> append the ascii file instead of overwritting it.
> 1) Does anyone know how I could check for the existance of a text file on
> the server from within a dts package and stop the package if it exists?
> 2) Does anyone know how to change the a SQL-table-to-ascii transformation
> so that it will append rather than overwrite an existing ascii file.
> Can't think of any code or other info I should be attaching, but let me kn
ow
> if there is something that I should be telling you.
> Charlie
>
>|||
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
Rumor has it that you're maligning my character in the private MVP
newsgroup. That doesn't seem very christian of you.