DSXchange

if we use
then does it make sense to use dscc to compile?? as dsjob -import , obtains only executables and executables are created from object code (after compilation) and linked libraries (I presume the answer is No, but still would like to confirm before I proceed with the design)

Why did you bother buying DataStage, if you're going to script everything?!

The group, which will be handling the code transfer to production is not going to have any datastage experience + security concerns requires that everything should be automated and no source code should be availabe in production.

Even I am boggled with the requirements. But I wasn't able to talk through the management procedures

How are you planning on compiling anything without the source being available? As you noted in your first post, that doesn't really make any sense.

If you are looking for a tool, that does import and compile from a windows command line you should concern "dsmove".