export text file από dts

sqlserver 2000 i have a dts, run inside sql statement and the final step is export text file in a specific directory, i make this dts as schedoule job, but when this job is running, the sql statement is complete successful but the export of the file is not created in a specific directory.

any help? thanks