Ssis remove text

SSIS and Import/Export
1

hi

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

2

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

3

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)

4

I acn usel left in 2008 any other way

5

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