I have source file with column
Jim k Smith
Robert K Lin
and My destination has
FirstName and LastName
I want to parse FullName
I know how I can use SSIS Expression to parse the address, Here it is
FirstName = LTRIM(RTRIM(TRIM(REVERSE(SUBSTRING(REVERSE([Full Name]),1,FINDSTRING(REVERSE([Full Name])," ",1))))))
LastName = LTRIM(RTRIM(TRIM(SUBSTRING([Full Name],1,FINDSTRING([Full Name]," ",1)))))
Is any one can help me to transfer in T-SQL?
Thank You in advance.