DSXchange

Hi, I have a requirement as: "There are 40 different xml source files with different metadata/schema. I need to create a single job which will read any of these xml files at runtime and convert it to a flat file. I need to create only one job for all the above requirements." I can do this ...

While trying to import data from a text file(fixed file format) using Schema File for a particular table, we are getting the error Input buffer overrun at field "FIELD_NAME", at offset: 202. Where "FIELD_NAME" is column in the target table. Please advise.

[* Post Contents removed, duplicate post, not appropriate for thread - Content Editor *]

I assume that you have tested your stored procedure in SQL server directly and get correct contents returned, so the first question would be how you have declared your datatypes. Actually, the output of the SP is a select stmt from a table based on some conditions. Hence we need not define any data...

We are calling a Stored Procedure from an ODBC stage. When we execute the SP in SQL Server, it should give the output as a single column having multiple rows of comma dilimited strings as shown below: COLUMN1 tttttttttttttt,59779597,kjjjjjjjjjj jjjjjjjjj,iiiiiiiiiiiiii,999999999 ddddddddd,88884224,b...

What happens when you try to fire the sql procedure outside of datastage? Any issues then? Any relevent help when you google 'SQLSTATE=42000 '? when I run the sql procedure in sql sqerver it is working fine. But in datastage it is not working. We have created a stored procedure with 3 parameters in...

here my source is sqlserver.we have created a stored procedure with 3 paramaters in sqlserver these are all input parameter there is no o/p parameters. we want invoke this storedprocedure in datastage using storedprocedure stage.in the datastage how can i pass these parameters.and where we pass thes...

iam facing a problem in STP stage iam getting these errors.


Stored_Procedure_26,0: Warning: map_test6.Stored_Procedure_26: SQLSTATE = 42000, fNativeError = 201 ,

i am waiting for responce :( There is nothing to compel anyone on DSXchange to respond to any post - it is an all-volunteer site and members post when and if they can. If they don't it may be that they don't have anything to add or, (quite unlikely) that they feel offended by something. If you're i...

chulett wrote:No "buffers" in PX jobs. You can do that in Server but not here. ...

Thanks a lot.
I split my job in 2 different sub job

Hi ,
I am getting compilation errorError: Property 'File' for 'Sequential_File_101' is required but empty.I am using sequential file as buffere in my job.Below is the flow of my job.
stage1---> stage----> sequential file-------> stage3-------->stage4.

Please advice

i am waiting for responce :( There is nothing to compel anyone on DSXchange to respond to any post - it is an all-volunteer site and members post when and if they can. If they don't it may be that they don't have anything to add or, (quite unlikely) that they feel offended by something. If you're i...

ray.wurlod wrote:Speed - as in elapsed time? Well, all else being equal, more partitions (up to a sane amount) should finish faster than fewer. Or you may prefer fewer partitions but more than one job simultaneously ...

Thanks a lot

What I would look at doing would be writing a custom BASIC routine that leveraged DSExecute() to delete whatever filename is passed in. Then your Server job could source from your control table, filter on your status code and select the filename into your job. Then in a transformer, call the routin...

Not just from that message... how exactly are you 'calling one job inside another job'? Are there any other messages logged, parent or child? ... i am passing parameter value ,parameter name ,job name to a routine and i am using this routine inside a transformer of parents job. in parents job i got...