DSXchange

Patch applied as per the advice above and this error is a thing of the past!

Thanks again all for the assistance :D

Just to let everyone know... The problem was that certain ComplexType elements had to be specified as MIXED=TRUE in the xsd file. Once this was done, the job ran. I am still experiencing some issues - the job is running to completion with green lines, but no data or rejects are being written.. this ...

We try to write a small job which uses a row generator to a file, and then in the second job in the sequence, we just append to the existing file. this works well for all cases where you need some text before the value and will work for header columns as well - you just define the header column as a...

Hi All, Well, having had all sorts of problems with v8.0 and XML, we are now reduced to going back to v7.5.2 to try and push out a solution. This, however, is causing its own headaches.. and starting to really turn me off XML in DS! :evil: Ok, we have an XML file that validates (in XML Spy) successf...

Thanks both very much for the assistance, much appreciated - I'll have a play and see if I can get the patch in place.

Cheers,
S

.Hi All, We have a job running on 7.5.2 that looks like this: Seq File ----> XML Input ------> TFM -----> Seq File The first sequential file contains a single column of longvarchar to store the incoming XML. This then goes via the XML input stage and a transformer to the last sequential file. The ou...

[quote="chulett"]Download the [b]XML Best Practices[/b] document from [url=http://www.duke-consulting.com]Kim Duke's website.[/url] It will lay that all out for you, how to combine intermediate chunks of XML into your final schema.[/quote][quote]Thanks for showing me the right place. But d...

[quote] I want to generate a one master XML file , which has the master records at the begining and at the end it will have the reference/enumeration data. I am building multiple XML files from the different tables and then I am trying to club/merge these XML files as per the schema defined for it. ...

Hi All, We have a generic multi instace job which is processing some files. The input files are having different structures ,so we have used schema file to validate the meta data. Some files come with header record(column names). So I want to define in the schema file as first line is column name. I...

Hi All, I am getting errors while inserting records from sequential file to sqlserver table. My seq file contains data like this ------------------------------------------------------- name,header_date,start_date,no_of_records IB,2007-04-16 10:20:30,Apr 16 2007 ,300 ---------------------------------...

I deleted the stage variables.
Simply in the derivation stage of occurance column I used the index function like this index(input.filename,".",1) and its working fine.

thnx all

I chcked the job again. In the substring position I tried by giving empty string like index(input.filename,"",1) and it is returning 1 which is right,but thr indexfunction is not reading the ".". I also tried by assigning integer value to the stage variables as suggested by ray,b...

The data type of both the stage variables are Varchar.

Code:

Field(in.Data, ".", 1)

I tried this one,but getting 0,0 values.

The job is running sucessfully.
In the output I mean in the occurance column I am supposed to get values 5,5(Please check the 1st post) but,I am getting 0,0.
If I will use rowgenerator stage as source it will produce random values which maynt contain . part.