DSXchange

Hi, The source for the job is a Sybase database and i am generating the header,footer,body part of a file seperately and then in the after job I am combining the header,body and footer to generate the final outut file. In addition to that, 1.I need to write message to a log file indicating whether t...

Rajee - the important part of Ray's post is visible to you. ... ArndW,as per Rays logic, 1.I need to invoke the batch file through the after-job subroutine and check for the file with 0 byte and abort the job. My queries with respect to Ray's response are, 1.How to invoke a batch file through after...

Go to the Columns grid. Right click on the appropriate row and choose Edit Row... This should open a dialog in which the extended properties of the column you are editing are displayed, and you sh ... Thanks ray,i got rid of the above error.But now I get the below info in the director and i have no...

Please delete your duplicate post on this topic. There are three possible stage types, comparable in terms of efficiency but subtly different in their method of operation. S ... Sorry ray,the posts are different but the subject lines were same for both and has created discrepency. Can you let me kn...

ray.wurlod wrote:

Rajee wrote:Hi,

Can anyone let me know if Row splitter is the only stage through which a file with a header,body and footer can be split seperately or is there any other stage/way through which ...

I have done it through server job using the transformer stage.

Of course you can. You can execute a pipeline through ExecDOS (for example command1 ; command2 ) or you can create your own after-job subroutine that invokes the batch file and tests for ... Ray,as Iam not able to view your response fully I am not able to understand your logic/solution fully and im...

Setting the second argument (ErrorCode) of an after-job routine will abort the job. If you are using ExecSH or ExecDOS it should be sufficient to execute a command that will fail, for example mr ... Ray I am not able to have a complete view of your reply,hence still no clue about implementing the a...

Setting the second argument (ErrorCode) of an after-job routine will abort the job. If you are using ExecSH or ExecDOS it should be sufficient to execute a command that will fail, for example mr ... Ray I am not able to have a complete view of your reply,hence still no clue about implementing the a...

Hi,

If the storedprocedure extracting data from the source tables returns no record, then I need to abort the job.
I guess it can be done in the after job routine by calling some batch file.If so,can anyone let me know the DOS command through which i can abort the job.

Thx,
Rajee

hamzaqk wrote:are you being able to view data in the two sequential files ?

No,I am not able to view the data,instead the same above error message is displayed.

It's all in the message - the Field Width property is not set. ... I dont find any attribute named "width" in either the sequential file stage or the compare stage.instead there is an attribute named "lenght" and that is assigned a value as 15.Can you let me know where you expec...

Hi, I am trying to compare two files through the compare stage,i have imported the metadata of two files and set all the required properties.I have also checked for the metadata imported for the field "cnvrt_trd_crrnb_rt" and it is Decimal with length 15 and no scale,but when i try running...

hi, I did it in the after job subroutine through unix command by checking for the word count in the file.if the wordcount in the file is 0 then i appended 0 to the file. But now i need the same to be implemented in windows server for which I am not able to find the command to do the above check. Kin...

Hi,

Can anyone let me know if Row splitter is the only stage through which a file with a header,body and footer can be split seperately or is there any other stage/way through which the file can be split.

Thx,
Rajee

If you want a dataset with just the keys, use a modify stage after your compare. Either specify DROP and list the columns to drop, or specify KEEP and list the columns to keep. When you say 'read the data from data set', what do you want to do with it? We need more info. Brad. I am comparing two fl...