Removing last 3 characters

How do I remove the last three characters in the string using a derived column?

SELECT column, STUFF(column, LEN(column) - 2, 3, '') AS derived_column


They probably didn't explain it right. I can't use any SQL. I have to use ssis logic if possible. is there a way of doing it without using sql

Hopefully someone else can provide that, I am more a SQL person.

Use as expression of your derived column:

No problem thanks

I keep getting an error on this. I have changed the brackets as well to this


Any idea why it would get erros. Also chnaged rhe name of the columns to my column names

LEFT and LEN are functions so they need ().


that worked thanks