|
Brittney10
Posting Yak Master
USA
128 Posts |
Posted - 11/14/2012 : 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. |
Edited by - Brittney10 on 11/14/2012 14:31:03
|
|