DSXchange

Try doing a reset of your job from the director and most likely there will be a message with additional information.

A "CSV" file is a text file, it stands for "comma separated variable" and it is just a simply formatted text file legible through every text editor and display tool.

Yes, but it is not easy or straightforward to do. Either just do full project exports into .dsx files which are checked in & out (simple method); or go through all the work of making a .dsx for each and every object and checking those in & out separately. Either way it is an unsatisfactory s...

look at the file with an editor would be one way.

Please re-read the answers to your original post before posting the same question in another section.

You need to find out which part has gotten slower. Measure the speed of the job, then make a copy and repalce everything after the initial DB2 read stage with a sequential file writing /dev/null. Run that new job. If the speed is similar to the original job then most likely the DB2 read is not causi...

Is your delimiter a "space" character in the csv? It looks like you declared the wrong delimiter and your first column, AGENCY_IDENTIFIER", is VarChar(25)

I'm having trouble visualizing how an XML input stage could work in parallel - but the designer object allows the execution mode to be specified as "parallel" so perhaps it does work Have you tried that setting?

sunhilsarin, I'm not sure about the others, but I think that joining a forum and, in your first post, asking "give me {free} stuff now" is not a good start. I certainly don't feel like going and writing up a precis and emailing it to. Have you read the "read me"? It describes how to use the Search f...

Which part gave you errors - the reading from SQL server or the writing to Oracle? What was the error?

Ray - Genius, pure Genius

You are doing more than simple reading & writing - is it possible that you have a sort stage in there somewhere, perhaps an implicit sort? Are you repartitioning during the course of your job? The solution to your problem is to redesign your job to make more efficient use of the resources you ha...

My first thought is that you should use the Aggregator Stage to compute your minimum and maximum dates but something tells me there must be more involved.

What userid are you using? if you attach to "/dspx00/Ascential/DataStage/DSEngine" can you do a "touch testfile" (if yes, then "chmod 777 testfile" and "rm testfile")

This error can happen for several reasons, but is most often seen when using RCP (runtime column propagation). I cannot see how the same job, recompiled, will work on one machine and not on another, though. What stage is giving this error, and what are the column definitions of the stage before that...