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 |
|
ravi3005
Starting Member
1 Post |
 Posted - 2011-08-31 : 14:45:25
|
| am loading flat files into sqldb.am having column in flatfile with values like 35.00gm1.80oz 24.00g2.80oz In Flat file source connection spaces are coimng like  35.00g and  24.00g how can avoid that  in Source?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-01 : 00:14:27
|
| use TRIM() function in ssis to remove space. other characters can be removed by REPLACE(). you can do this conversions inside derived column task which will linked from flat file source in data flow task------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
elimate spaces in source ??