DSXchange

Dont change it. Just build another job to do the same except, without the link collector. This is just for debugging purposes.
I have had issues with link collectors and hashed files (connected together) before and therefore dont like them next to each other.

I am still not able to understand whats the use of the parameter if your not using it for your transformations. Anywho, the following should work For #1: StringToDate(DecimalToString(YearFromDate(CurrentDate())-1):"-12-01", "%dd-%MMM-%yy") and for ...

Forget the trim function. Use the Field() function to extract everything before "(".

What happens when you write to the same hashed file from these 18 hashed files without the link collectory?

....more like how do keep chicks interested.

Well the permissions look fine. I am running out of ideas now. I guess its upto you. Put a bunch of echo statements in both your scripts. These statements will show up in the log. See how far it goes without breaking.

Dont make it restartable. And yes, reset it and then run. It will run from the begining.

Then how do you expect us to help you? No info of even the design, what your trying to do in the job, the data volume etc etc etc

What do you mean freezing? Is the designer client freezing or the job is hanging? What additional messages do you get in the log file? Reset the job and see if you have any messages "From previous run ..."
Need more info on design as well.

At a glance the scripts look fine. Just make sure that both scripts have permission to be executed by your datastage id.

Actually it was all Ken. I just translated his suggestion in code. Thanks Ken

Pass your date in the format YYYYMMDD. Your query will look something like this select * from myTable where week_code between (SELECT week_code FROM time_dim where FISCAL_DATE = #dateparam#) AND (SELECT week_code FROM time_dim where FISCAL_DATE = TO_CHAR(TO_DATE(#dateparam#,'YYYY...

Do it in a job. Get all the info into a flat file and then load it into the table. You dont have to do it in the after job sub-routine.

I hope you are initializing all the variables ($) inside your script. The script looks ok. Post your entire script please.

Handle all errors inside your script and exit explicity using a return code of 0 for successful and 1 unsuccessful.