January 23, 2013 at 9:26 am
Hi friedns i have small doubt in ssis plese tell me how to solve this issuse
i have source table and that table contains data like
id , name , sal
1000 , ravikumar ,20000
120 , venu ,24000--- this row id contains starting 1 space
1400 , ravikuram ,14000 ------this row id contains starting 2 spaces
24 , kamal ,2500 -------thie row id contins staring 4 spaces
so this records data load into another table .how to avoid spaces in ssis .
i use rtrim in derived columns but its not solved . plese tell me how to solve this issue in ssis packages
January 24, 2013 at 12:34 am
You can use the REPLACE function to replace every space with nothing.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 12, 2013 at 12:29 am
RTRIM only clears off spaces on the right side of the text. So, you better use LTRIM(RTRIM(ID)) in your source query itself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply