I have a column of data that I'm trying to import into a SQL field that has a length of 1000. However, the data that is being sent may have columns with 1000+ characters....which would cause truncation. Since this is a note field, what i need to be able to do is only take the most recent 1000 characters going from Right to Left. How do i do this in SSIS? Thanks for the help/suggestions ahead of time.