Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssis space problem Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 9:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 10:21 AM
Points: 197, Visits: 4,400
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
Post #1410676
Posted Thursday, January 24, 2013 12:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 12,239, Visits: 9,212
You can use the REPLACE function to replace every space with nothing.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1410937
Posted Tuesday, February 12, 2013 12:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 06, 2013 1:45 AM
Points: 19, Visits: 75
RTRIM only clears off spaces on the right side of the text. So, you better use LTRIM(RTRIM(ID)) in your source query itself.
Post #1418772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse