SSIS Tutorials - 4.Derived Column - Split Names in SSIS
In this tutorial, I will show you how you can split names and columns in SSIS, and you can use the below codes with proper changes.
SQL:
Select Name, SUBSTRING(Name, 1 ,Charindex(',',Name)-1) As LastName ,
SUBSTRING(Name, Charindex(',',Name)+1, LEN( Name ) ) AS FirstName
From [dbo].[Employees Table]
SSIS:
LASTNAME: SUBSTRING([Name ],1,FINDSTRING([Name ] + ",",",",1) - 1)
FIRSTNAME: SUBSTRING([Name ],FINDSTRING([Name ] + ",",",",1) + 1,LEN([Name ]))
Last but not the least, SUBSCRIBE to my YouTube channel to stay updated about the regularly uploaded new videos.
Linkedin : / mohammed-rasool