Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Brittney10
Posting Yak Master
154 Posts |
 Posted - 2012-11-14 : 13:41:42
|
| 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. |
|
|
Brittney10
Posting Yak Master
154 Posts |
Posted - 2012-11-14 : 14:30:46
|
| At first i wasn't getting the right results...human error i believe, but a simple RIGHT([COLUMN], 1000) works. |
 |
|
|
|
|
|
Right(Column)?? - RESOLVED