calling musugu_veerudu & others [SQL doubt]

[geeni83]

[quote author=charygaru link=topic=217792.msg2681305#msg2681305 date=1311919032]
darling loooooooong time wass up !!! igo chsinav kada naa badha itla unna wazz up with u ??
[/quote]

em led baa mana weekend jatara start chesaaa... db lo tirugutunna  ... ee sql naku raadu ba... lekunte helping sesetodni

[charygaru]

[quote author=tom bhayya link=topic=217792.msg2681308#msg2681308 date=1311919169]
adhey chary garu mee file delimiter space aa file anthey vuntundhi.. 2005 import tool lo delimiter space ledhu antunnaru kabatti.... so meeru nenu cheppinattu proceed ayipondi..
1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file. use FlatFile Destination as  'Fixed width with row delimiters' instead of 'Fixed width' option.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to replace spaces with colon.
      Use this expression inside expression builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")


adhi chesthey u will get a new text file with delimiter colon.. so now you can easily import using import/export wizard..
[/quote]

refu ofice lo oka sari try chestha mama raakapothe m musal daaniki edo story cheptha inka thanks for the help edanna unte Mail chestha baa thaks so  much

[charygaru]

[quote author=JAINTR link=topic=217792.msg2681309#msg2681309 date=1311919169]
em led baa mana weekend jatara start chesaaa... db lo tirugutunna  ... ee sql naku raadu ba... lekunte helping sesetodni
[/quote]

lite baa ochhina vallu baaga helf sesaru ade padi velu [img]http://www.gifsoup.com/view2/1906073/tanks-o.gif[/img]

[geeni83]

[quote author=charygaru link=topic=217792.msg2681325#msg2681325 date=1311919471]
lite baa ochhina vallu baaga helf sesaru ade padi velu [img]http://www.gifsoup.com/view2/1906073/tanks-o.gif[/img]
[/quote]

gif aripinchaav ba  CITI_c$y CITI_c$y CITI_c$y CITI_c$y

[tom bhayya]

[quote author=charygaru link=topic=217792.msg2681322#msg2681322 date=1311919430]
refu ofice lo oka sari try chestha mama raakapothe m musal daaniki edo story cheptha inka thanks for the help edanna unte Mail chestha baa thaks so  much
[/quote]
vaakey baa nenu inka sleefing... mrng aapice ki vellali...

[Jeffa]

cahry gaaru file baaga corrupt ayyindi andi....daniloo ee column ki ee value oo teliste edaina delimeter ni kanukovataniki untundi emo... sCo_^Y sCo_^Y

[charygaru]

[quote author=JAINTR link=topic=217792.msg2681327#msg2681327 date=1311919535]
gif aripinchaav ba  CITI_c$y CITI_c$y CITI_c$y CITI_c$y
[/quote]

10K posts esa kada mama aa matram nerchukokunte fublic feel aitharu [img]http://www.gifsoup.com/view/750502/ali-o.gif[/img]

[geeni83]

[quote author=RODEO link=topic=217792.msg2681334#msg2681334 date=1311919631]
cahry gaaru file baaga corrupt ayyindi andi....daniloo ee column ki ee value oo teliste edaina delimeter ni kanukovataniki untundi emo... sCo_^Y sCo_^Y
[/quote]

nuvvi sql dba na baa

[charygaru]

[quote author=RODEO link=topic=217792.msg2681334#msg2681334 date=1311919631]
cahry gaaru file baaga corrupt ayyindi andi....daniloo ee column ki ee value oo teliste edaina delimeter ni kanukovataniki untundi emo... sCo_^Y sCo_^Y
[/quote]

2000 is the fixed width kada baaa so file corrupt ayyindi lenidi telvadu manaki anyways tom bhayya ichhina solution try chestha repu work out kakunte appudu chusukovachhu iga nenu sleef estha

[Jeffa]

[quote author=JAINTR link=topic=217792.msg2681338#msg2681338 date=1311919724]
nuvvi sql dba na baa
[/quote]kaadu baa...[quote author=charygaru link=topic=217792.msg2681343#msg2681343 date=1311919793]
2000 is the fixed width kada baaa so file corrupt ayyindi lenidi telvadu manaki anyways tom bhayya ichhina solution try chestha repu work out kakunte appudu chusukovachhu iga nenu sleef estha
[/quote]2000 fixed width of each column ah  sCo_^Y leka for each delimeter ah??

[charygaru]

[quote]1. Take one Dataflow Task Control from ToolBox.

  2. Inside Dataflow Task take FlatFile Source control and select your file as input file. use FlatFile Destinati on as  'Fixed width with row delimiter s' instead of 'Fixed width' option.

  3. Then use the REPLACE() function inside a Derived Column after FlatFile Source component to replace spaces with colon.
      Use this expressio n inside expressio n builder of Derived Column. DataType should be String(DT_STR) and length 255.

  REPLACE([column_name], " ", "")
[/quote]

step two daaka baagane undi kaani akkada naaku "'Fixed width with row" instead of 'Fixed width" option ledu mama  sCo_^Y sCo_^Y

and also step 3 lo ee replace() function endi saami nenu only GUI vaadutha nuvvu gaani edanna code rayamannava nannu  sCo_^Y sCo_^Y