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