DSXchange

Source is csv file with the data format as 3/30/2013 09:04:05, reading as varchar(26) . Target is sql server database with datetime datatype .

function used
StringToTimestamp(Lnk_MapTargetColumns.Date_Received,"mm/%dd/%yyyy %hh:%nn:%ss")

getting the below error:
APT_CombinedOperatorController,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "mm/%dd/%yyyy %hh:%nn:%ss" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid format [mm/%dd/%yyyy %hh:%nn:%ss] used for string_from_time type conversion.

What is the error in the above function used

Your main problem is that you are missing the "%" in front of the mm.

% you have to put in before mm as suggested. However i noticed that its one digit month without filler. You might wanna try %m/%d....