ssis space problem

  • 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

  • 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

  • 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