SQLTeam.com | Weblogs | Forums

Ssis remove text



how do i remove the brackets and text in the back using ssis
Noah 1 S.p.A. (Ordinary shares)
Noah 1 S.p.A


I would create a staging table and transform the data in SOL Server.


You can use a derived column transformation and build an expression to parse the data. You can replace the existing column data or create a new column and pass that through to the destination.

The code would be a combination of LEFT/SUBSTRING and FINDSTRING depending on the actual string values you are looking to remove and where they show up in the string.

Something like this should work: LEFT(yourcolumn, FINDSTRING(yourcolumn, "(", 1) - 1)


I acn usel left in 2008 any other way


If you cannot use LEFT then use SUBSTRING instead...