DSXchange

So is it working now or still issue?

Is the first line in the file has column names?

got the answer: viewtopic.php?t=131357

How we can use $APT_PM_PLAYER_TIMING to identify the cost of CPU time for each stage in the job?

Use the following code..
If (IsNull(Column) Or Column = '') Then SetNull() Else StringToTimestamp(Column:' ' :'00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")

Use stage variable which will do the check on the length of the string.
If length is 10 use same date else 0:date
In the ETL translation, use the function StringToDate.
I recommend this way to make debugging easy for you. Use this as tip.

The stage in sequential mode will wait till all records are processed and avaliable, then stage will process them and avaliable for next link. So you are using the copy stage with sequential mode. So it is using same ES_ID I guess. Use this as a tip.

StringToDate('03/21/2011',"%mm/%dd/%yyyy") . This will do.
Initially please know the format of your D_TRADE_DATE.
Then it will be easy for conversion.
For that use peek to debug the date format.

one of your timestamp column in the OC is not accepting the value, as the value is not a valid timestamp.

"How to abort DS job when the condition in Transformer stage is not met".

When I execute the job I want to pass in a number parameter ie. 100 and then to check if that number matches with the input file count in the job. If it does, I want the job to continue otherwise to abort?

Job2 is loading the data into table2.

sql is using table2 and if load complete, it can see the object. If not, it says "object no longer exists".

Issue resolved.

In the sequence, there are four jobs (they all in parallel.) and the one I got issue is using the result of the second job.

Thanks.

I'm getting following error and failing the seuencq first time and when I restart the sequence, it's finishing succesfully. DB_WB_SRC02,0 (Object : Oracle Connector name) : The OCI function OCIStmtExecute returned status -1. Error code: 8,103, Error message: ORA-08103: object no longer exists. (CC_O...

Try with the following code.
It works fine for me.
If DSLink3.count = AsInteger(StringToDecimal(TrimLeadingTrailing(DSLink3.value))) Then "Y" Else "N"

Use fileset stage instead of sequential file stage in your job as source reader. Can anyone let me know,how can we process a text file that is pipe delimited and is of more than 5GB in size. Other than splitting the files into multiple is there any other way/stage through which the file can be read ...