DSXchange

Thanks vmcburney. I tried this and it works. I like the way you also explained to why this happened. Appreciate that. Thanks

My job design is like this Source --> Transformer(to split 3 data streams) -->Row Splitter (three of them one for each stream)---> Transformer(to transform data - three of them for each stream)---> Row Merge (three of them for each stream)---> Transform(to create a key column-three of them for each ...

Thanks ARNDW. Yes I am actually stuck in the next step. I have now generated 3 files - Header, Detail, Trailer using Transformer/Row splitter. However I wouldnt be able to use a Merge Stage to merge the Header file, Detail file and Trailer file since they have different columns. I wouldnt be able to...

Thanks ArndW. I would need the header/trailer data as well. I would have to bring them out in the same order as header detail1 detail2 trailer header detail1 detail2 detail3 trailer And a header/detail/ trailer consists of different number of fields Do I bring them as a single field into the transfo...

Thanks for the suggestion.
I have opened a new thread on the issue I am facing

Hi All: I have to extract a sequential file which has the following structure: Header Detail1 Detail2 Trailer This structure repeats itself in the file. The first 6 characters in a line indicates the type - Header/Detail/Trailer. However Detail line can be 1 or many between a header and trailer. I w...

Hi All, this closely resembles my case but I have Header->Detail(s)->Trailer structure repeating in my source file. Target file would also have to be written the same order. How do I go about creating this ?
Any help on this is appreciated !

Thanks

Hi: We are facing an issue with one of our QualityStage jobs The REALTOR data file contains two columns. The first column [Company_Name] should be 200 characters and the second column [Type] should be 1 character. I am attempting to standardize the names (Inc. -> Incorporated, Inc -> Incorporated) s...

That resolves my doubt. Thanks vmcburney

Another observation on this. I had to provide A SQL Server Authentication in order to make MS SQL Server Bulk Load work. Windows NT Authentication credentials did not work with this stage

Thanks Satyakunta
I tried the same. It works. Thanks for the help

Any idea if $0 cost upgrae holds good for QualityStage as well. I am interested to know this since we are on maintenance for this product Thanks

You can resolve this by giving the "administrator" user credentials in the Schedule tab in DataStage Administrator. If this is left blank, permissions of Windows system scheduler are used by Scheduler to copy files. And hence the error message because of insufficient permissions for the sy...

I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration.
Any pointers please?

Hi I am trying to use MS Bulk Load stage to load 6 million plus records from a sequential file. Underlying database is SQL Server 2000 on a different server machine than the DataStage Server. I have created a DSN with SQL server driver and passed it to the properties I get the following error Intern...