DSXchange

Thanks for Reply It is in this format:



Derivation :
"TimestampFromDateTime(StringToDate(JoinCombine_Master_Ref.TrailerTimeStamp,"%yyyy-%mm-%dd"), StringToTime("00:00:00","%hh:%nn:%ss")) "

Column Name:

SRC_PROCESS_DTTM

Thanks Arnd,

It is a String Type "Varchar".

Arnd,

used the suggested code. The Job Failed and got Aborted. with these fatal Errors..



Target_Database,3: Failure during execution of operator logic.

Target_Database,3: Input 0 consumed 0 records.

Target_Database,3: Fatal Error: Invalid time

node_node4: Player 14 terminated unexpectedly.

Thanks for the reply: This is what i am giving in my target output field Derivation : "TimestampFromDateTime(StringToDate(JoinCombine_Master_Ref.TrailerTimeStamp,"%yyyy-%mm-%dd"), StringToTime("00:00:00","%hh:%nn:%ss")) " Column Name: SRC_PROCESS_DTTM On Compi...

Hi All,

getting this error for Time stamp. CAn any one help in this


ValidateAndSplit,3: Invalid value for this date type: **********.
Invalid value for this date type: **********.
Invalid value for this date type: **********.


Gul