mtkr Posted November 5, 2012 Report Posted November 5, 2012 [quote name='Jeedeelu' timestamp='1352140128' post='1302747270'] 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.. [/quote] ya mama max2max row delimiter cr-lf e pettukuntam and max ade untadi... kani specific ga eadina mention chesthe (like in this case ; ) ade teesukovaali gaaa... lekapothe data sarigga raadu anukuntaa gaaa!!!!!
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='mtkr' timestamp='1352140328' post='1302747301'] ya mama max2max row delimiter cr-lf e pettukuntam and max ade untadi... kani specific ga eadina mention chesthe (like in this case ; ) ade teesukovaali gaaa... lekapothe data sarigga raadu anukuntaa gaaa!!!!! [/quote] naku thelisi ikkada edo oka delimiter use cheyalani semi colon use chesaru.... mostly memu other types... (~) use chestham...
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 [quote name='Jeedeelu' timestamp='1352140128' post='1302747270'] 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.. [/quote] CR-LF Istey Loading Fail avtundi because konni rows of Data ki Last Field lo Data lekapotey i.e. NULL untey adi aah Field ni single row laaga consider chestundi. Andukani Semicolon pettanu but ippudu Tab delimiter use chestunnaa choodali adi work avtademo ani
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 [quote name='Jeedeelu' timestamp='1352140427' post='1302747312'] naku thelisi ikkada edo oka delimiter use cheyalani semi colon use chesaru.... mostly memu other types... (~) use chestham... [/quote] (~) idem delimiter naaku kanpistalledu SSIS lo
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 Kaani okatey ardam kaavatledu naaku Previw lo data baganey kanpistundi kaani Load chesaakaney Issue vastundi,
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='DARLING...' timestamp='1352141179' post='1302747414'] CR-LF Istey Loading Fail avtundi because konni rows of Data ki Last Field lo Data lekapotey i.e. NULL untey adi aah Field ni single row laaga consider chestundi. Andukani Semicolon pettanu but ippudu Tab delimiter use chestunnaa choodali adi work avtademo ani [/quote] actual ga.. nuvu text file lo e delimiter vadithe ah delimiter ivvali... ne text file lo Tab vunte between field to field... thts fine... vadakapothe no use anukunta...
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='DARLING...' timestamp='1352141258' post='1302747423'] (~) idem delimiter naaku kanpistalledu SSIS lo [/quote] vundadhule.. andhuke Header row delimiter CR-LF use chesa... ne text file lo kuda instead of ; use ~.... try cheyadam veelu vunte cheyyi okasari... okasari import wizard use chedham ippudu..
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 [quote name='Jeedeelu' timestamp='1352141563' post='1302747465'] vundadhule.. andhuke Header row delimiter CR-LF use chesa... ne text file lo kuda instead of ; use ~.... try cheyadam veelu vunte cheyyi okasari... okasari import wizard use chedham ippudu.. [/quote] import export petta ippdey its Loading, anni avey chaanu details
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 [quote name='Jeedeelu' timestamp='1352141321' post='1302747434'] actual ga.. nuvu text file lo e delimiter vadithe ah delimiter ivvali... ne text file lo Tab vunte between field to field... thts fine... vadakapothe no use anukunta... [/quote] field to field | unid , but row delimiter maatram Memu set chestunnam issue vastundi NULLs valla last field lo ani.
Darling999 Posted November 5, 2012 Author Report Posted November 5, 2012 denemma jeevitam edi use chesinaa adey issue, import export kuda tried
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='DARLING...' timestamp='1352142355' post='1302747562'] import export petta ippdey its Loading, anni avey chaanu details [/quote] ah import wizard lo... anni next next next ani koduthu pothe... edit mappings vuntadhi.. danilo edit sql code ani vuntadhi... ah sql code lo e column lo ayithe white space vundho.. ah column deggara LTRIM() petti... run kottu...
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='DARLING...' timestamp='1352142439' post='1302747574'] field to field | unid , but row delimiter maatram Memu set chestunnam issue vastundi NULLs valla last field lo ani. [/quote] nuvu vertical bar | field to field use chesina... null ki null madhayalo | vuntundhi... so loading lo kuda prob lekunda null vellipothundhi...
gundugadu Posted November 5, 2012 Report Posted November 5, 2012 [quote name='DARLING...' timestamp='1352136252' post='1302746592'] Nenu oka Flat file Load chestunna SQl Table ki, 2 fields unnayi Field 1 | Field 2 12345 Name Nenu table loki Load chesaaka '12345' ' 12345' ani vastundi. 2 spaces add avtunayi. Evarikainaa idea untey cehppandi very urgent/. [/quote] baaaaaaaaa neeku problem leka pothe nuvvu load cheddamanukunna files ni PM cheyyi data antha avsaram ledu oka 10 recods vunte chalu. nenu try chestha
Ranga_The_Donga Posted November 5, 2012 Report Posted November 5, 2012 [quote name='gundugadu' timestamp='1352142985' post='1302747642'] baaaaaaaaa neeku problem leka pothe nuvvu load cheddamanukunna files ni PM cheyyi data antha avsaram ledu oka 10 recods vunte chalu. nenu try chestha [/quote] naku bhi file pampu....
chelsea Posted November 5, 2012 Report Posted November 5, 2012 nenu eppudu flat file nuchi load cheyyatam work cheyyaleda ba only sqlserver
Recommended Posts