DSXchange

please can you give more information from director log for further analysis of your problem.

Oconv(Iconv("06/17/2009" ,"D MDY[2,2,4]"),"D/YMD[4,2,2]") gives the output 2009/06/17.

i think you know that data in hash file is key to data mapping, so i think their can be no way to preserve order.

sorry dear but please post the message in parallel section.

please provide us with more details on error messages you receive.

Please can you paste an error message you get in Director and what is your data in input for further analaysis.

i have a job which creates more information/log, i am just able to see last 100 entries in Director, i want to know where i can do any settings so that i am able to see all log/information for particular job. And please may i know whether i can directly open any RTlognn file in notepad to view job i...

i think you need to read a file and in transformation you can do processing.

when you do testing of any routine( transform) you can see output in Test output.

after running your code.

please paste your code for while loop for us to check, below syntax works fine with 7.5.1a version.

loop while i < 8 do
print i
i=i+1
repeat

As said earlier by Andrw and Ray, you can use a before job subroutine and code
ErrCode = DSRunJob(JobHandle , RunMode)
DSJ.RUNRESET Job is to be reset.

Reading help topics on DSRunJob can give you more idea.

please search for the forum, you will have some uitility called dsexport

creating a trigger will help but depending upon your transactions for insert,upate and delete for number of rows their will be performance issue which you have to check out with your DBA.

Let your job write entire file even if it exceeds size, in after job subroutine execute one batch script or shell script.

this script will telnet the remote server check for the size of file and then use the utility dssmtpmail.exe to send mail ( check for setting with SMTP server).

you should know entire or exact name of file.