DSXchange

You could have a reject link from the file from which you are trying to read. The invalid records of variable length will sent to the reject link file.

Yes thats right...

Hi I happened to read the manual for filter stage... please check below. The operation of the filter stage is governed by the expressions you set in the Where property on the Properties Tab. You can use the following elements to specify the expressions: Input columns. Requirements involving the cont...

Check the datatype of Var1 job parameter. Check if it is String.

Is #Var1# is a job parameter?

Got the solution.
If you check the value I was specifing if the date was invalid was '0000-00-00' I changed that to '9999-12-31' It worked. Thanks you AndrW.

Yes i did as your suggested it did not work

:(

Thanks AndrW. I used the below condition svCustEffDate= If Trim(Lnk_Trn_Columns.CUID_ID_EFF_DATE)='' OR Trim(Lnk_Trn_Columns.CUID_ID_EFF_DATE)='0000-00-00' OR Trim(Lnk_Trn_Columns.CUID_ID_EFF_DATE)='1911-11-11' Or Dcount(Lnk_Trn_Columns.CUID_ID_EFF_DATE,'-')<>3 Then '0000-00-00' Else StringToDate(Ln...

I checked the output of
DCOUNT(Lnk_Read_PHONE.PHONE_EFF_DATE,'-') it says 3 for a correct date.

What does #2 mean here

Hi Changed the code and had the trim function with proper closing brackets I yet get the warning....

Hi All, I am checking if the incoming VarChar(10) field is a valid Date or not. Its a not nullable column. I could have spaces and '0000-00-00' I found some useful post in the which reduced the following warning but I yet receive some of them. Warning received is APT_CombinedOperatorController,1: Co...

Thanks for the reply.
But i do not relie on the link count because the link count behave weird at times and give some different count I don't know why.

Hi, I need the count of records in a paralled job. I separate the data based on the conditions (constraint) from the transformer stage and send them to the aggregator stage to count the records. I had a quick question here do I need to sort the data based on the key column before sending it to the t...

Thanks for reply. I don't want to use a script. Yes, Ray the header looks like 1107081700153721HEADER DPCUSCOM and trailor looks like 9000000000051853TRAILER But both these have length same as the record lenght with spaces appended at the end. We can identify the record based on the words HEADER and...

Hi All, I have gone through the posts here for removal of header and trailor records from a file. I found that these posts has a requirement where the header and trailor were of different format hence we can automatically reject the records while reading the file. I have a fixed width file where in ...