DSXchange

Thanks for the inputs my jobs are working for that type of example. If you see the above example all the header, detail and trailor are of the same length of 86 and it was easy to design and run the job. Now i have some files which have columns delimited by pipe( "|" ) and also the header,...

which function to use in the transformer to get for example the characters from 16 to 22 in the field of 86 length?

the file format is as below HDRBAE001I 200808141008000989 CREDITCARDDATA.TXT 00086 10A20080813240893 0058940918190296242291182201108GAMBUCCI, JESSE J PUS 10A20080813544909 9687940918190338143607381201108JULIANO, LILY PUS TRL200808141008000000029 I have given only one detail record as sample. HEADER ...

Iam trying to process a file....which contains header, detail and trailor. Header and trailor are not same length and my job is seq file....transformer .....seq file. The link before the transformer is showing the number of rows processed but it is not passing through the transformer and getting zer...

sorry it is Microsoft Visual C++ 6.0 that is installed

i have Microsoft Visual C++ installed on my server...does this helps to compile jobs instead of MS VS C++ 2003 ?

Thanks

thanks...they are showing up now.

When i exported a project and imported to new project in new server......i am not seeing any stage variables. What's need to be done to see the stage variables in the imported job designs?

I have a scenario like the following: emplid name_type name 12345 PRI John doe 12345 PRI John King I need to apply same conversion routine to name column, then it becomes like this emplid name_type name 12345 PRI Kodf urt 12345 PRI Kodf fkgk emplid and name_type are columns that i am using to update...

I have an environment variable for tns service name as for example a_b, but due to some reasons i want to change to a.b. How can i change it so that it can reflect in all the jobs in the project ?

Thanks for the response...Is it compulsory to give the job parameters in the sequencer job activity? or will it use the parameters that already there in the underlying job? I think the job parameters in the job activity are needed only if we need to overwrite the job parameters of the underlying job...

Will compiling a sequencer compiles all the underlying jobs?

Thanks

While i was designing sequencer in the designer and when i click any job activity i am facing memory errors (saying it could not write to memory) and forcing me to close the designer. This is happening very often and very irritating! How can i avoid it?

Thanks

I am doing an insert into oracle table from dataset using upsert. I am getting this error many times and job is aborting. Each time this is happening on different nodes. sqlcode is: -12571esql complaint: ORA-12571: TNS:packet writer failure Unable to insert record into table. Records Inserted: 0 Rec...

i used time and row interval (ora_upsert) as 1 million (1000000).