Calling Ssis Experts..!

[Darling999]

[quote name='chelsea' timestamp='1352138405' post='1302746989']
u can use Transformation derived column or copy column and use trim function in it
[/quote]

nAAKU FLAT FILE LO SPACES LEVUU, sO TRIM CHESINAA EM FARAK PADATLEDU.\

And one more thing enti antey okavela data load ayina tarvaatha Queryc chestey trim function use chesi No Data ani vastundi.
But Like option use chesi Mundu % peditey data vastundi sarey ani dantlo ki velli choostey spaces levuu..

ee issue naa madda laaga undi assalu ekkada prob oo kuda teliyatledu

[karna11]

[quote name='mtkr' timestamp='1352139177' post='1302747120']

[/quote]
nee location chusii nuvvu ravemoo anukunnam, Omkar annaya ranivvademooo anukunnam

[mtkr]

[quote name='chelsea' timestamp='1352138994' post='1302747082']
Derived transformation use cheyyi danilo expression lo R[font=Consolas, Menlo, Monaco,]TRIM[/font][background=transparent][font=Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, serif][color=#000000](column name[/color][/font][/background][font=Consolas, Menlo, Monaco,])or use Replace use cheyyi according to your Requirement [/font]
[/quote]

[Darling999]

[quote name='mtkr' timestamp='1352139222' post='1302747125']
like source vallu fixed length file pampisthunnaremooo.....
[/quote]

daani actual Size 30 but flat file lo 50 undi nenu change chesaa danii

[mtkr]

[quote name='DARLING...' timestamp='1352139292' post='1302747139']

nAAKU FLAT FILE LO SPACES LEVUU, sO TRIM CHESINAA EM FARAK PADATLEDU.\

And one more thing enti antey okavela data load ayina tarvaatha Queryc chestey trim function use chesi No Data ani vastundi.
But Like option use chesi Mundu % peditey data vastundi sarey ani dantlo ki velli choostey spaces levuu..

ee issue naa madda laaga undi assalu ekkada prob oo kuda teliyatledu
[/quote]

oke row ki test chesava???? r multiple records meeda testing chesavaaa???

[mtkr]

[quote name='karna11' timestamp='1352139311' post='1302747142']
nee location chusii nuvvu ravemoo anukunnam, Omkar annaya ranivvademooo anukunnam
[/quote]
anneyya manasu venna.....

[mtkr]

[quote name='DARLING...' timestamp='1352139347' post='1302747146']

daani actual Size 30 but flat file lo 50 undi nenu change chesaa danii
[/quote]
flat file source lo default length 50 e untadi anukunta gaa mama!!!!! incoming length ekkuva unte farak gaani takkuva unte no issue anukunta gaa!!!

[Darling999]

[quote name='mtkr' timestamp='1352139472' post='1302747167']
oke row ki test chesava???? r multiple records meeda testing chesavaaa???
[/quote]

prati record lo aah field value ki mundu 2spaces vastunnayi,

the file details are

Column delimiter is |
And Row delimiter is ;

adi first column data lo so ee row delimiter eminaa issue create cehstunaa ani alochistunna

[Darling999]

[quote name='mtkr' timestamp='1352139593' post='1302747182']
flat file source lo default length 50 e untadi anukunta gaa mama!!!!! incoming length ekkuva unte farak gaani takkuva unte no issue anukunta gaa!!!
[/quote]

yaa DB lo 30 untadi kada so velladu kabatti change chesaa 30 ki adv editor lo

[JUJUBI_JULABI]

madyalo derived column petti trim cheyy ..

[Ranga_The_Donga]

semi colon teeseyi...

head row delimiter {CR}{LF}pettu..

nenu ayithe idhe use chesthuna...

[mtkr]

[quote name='DARLING...' timestamp='1352139612' post='1302747187']

prati record lo aah field value ki mundu 2spaces vastunnayi,

the file details are

Column delimiter is |
And Row delimiter is ;

adi first column data lo so ee row delimiter eminaa issue create cehstunaa ani alochistunna
[/quote]
ya might be.... oka sari aaa source file loni 1 or 2 copy chesukoni ave load chesi chudu aa row delimiter teesei....CR-LF pettukoni chudu...
(for testing... telustadi ade error a kaada aniii)

[mtkr]

[quote name='Jeedeelu' timestamp='1352139828' post='1302747224']
semi colon teeseyi...

head row delimiter {CR}{LF}pettu..

nenu ayithe idhe use chesthuna...
[/quote]
ala ennitiki change chestam mama..... n process automate chesinappudu kastam kadaaa!!!

[Ranga_The_Donga]

[quote name='mtkr' timestamp='1352139993' post='1302747248']
ala ennitiki change chestam mama..... n process automate chesinappudu kastam kadaaa!!!
[/quote]
na pkg chesinappude... na settings ave.. delimited.. CR-LF... its working fine for me..

kani ikkada issue theliyatam ledhu...trail nd error vesthunam... sometimes length ekkuvu ichina kuda trailing spaces vasthayi..

[Ranga_The_Donga]

import ki ... import wizard vadachuga..? y ssis?