calling musugu_veerudu & others [SQL doubt]

[charygaru]

mama oka text file undi dantla full data undi aa data ni inko already exisiting table ki import chesukovaali kaani point endi ante aa table lo masth columns unnai kaani text file la only one colum lo ne anni values unnai ani chupisthundu import export wizard use chesthunte errors osthunnai etla cheyyalo neekemanna idea unda?  sCo_^Y sCo_^Y sCo_^Y sCo_^Y SQL server 2005  lo ??



delimiters em levu fixed length ani cheppindi maa musaldhi kaani fixed length entha anedi em ardham aythaledu  !q# !q# !q# !q# !q#

P.S:-- konni screen shots kaavalante estha ardham kaaledu ante  sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[pavan_613]

CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

[Gachibowli_Diwakar]

basic sql ochu kani .. naku ivi teleedhu charygaru  s%H# s%H#

screenshots aithe pettu .. someone might else help u

[charygaru]

[quote author=Musugu_Veerudu link=topic=217792.msg2680919#msg2680919 date=1311913426]
basic sql ochu kani .. naku ivi teleedhu charygaru  s%H# s%H#

screensho ts aithe pettu .. someone might else help u
[/quote]

idi em pedda vidhya kaadu mama !! database meeda right click chesi tasks-->import data--> wizard open ayyaka

source --> flat file = delimiter s= columns--> destinati on=table name--> next--> finish

anthe error osthe enduku ochhindo chudaali kaani naa point deggara endo delimiter s levu ani ma musaldi annadi em pettalo ardham aythaledu
mappings chusthe source --> 1 column destinati on lo --> 282 columns unnai  !q# !q# !q# !q# !q# !q#

[K.A.Paul]

@3$% @3$% @3$% @3$%

[charygaru]

[quote author=K.A.Paul link=topic=217792.msg2680944#msg2680944 date=1311913873]
@3$% @3$% @3$% @3$%
[/quote]

*7*^ *7*^ *7*^ *7*^ *7*^ *7*^

[the_fairy]

ayyooo  sorry2 sorry2  sorry2  CITI#H@ CITI#H@ CITI#H@ CITI#H@

[Gachibowli_Diwakar]

text file kakunda.. oka sari Open with Word-pad tho try chesi chudandi charygaru oka sari

nenu epudu data loading cheyyaledu .. using flat-file or anything  sSa_j@il

[volley]

PM chesa.. reply me bak mama..

[volley]

teamviewer peduthava? i'll see if i can  S%Hi S%Hi

[charygaru]

[img]http://i56.tinypic.com/29nbdhv.png[/img]

akkada columns unnai kada avvi nimpaali nenu text file lo unna data toh kaani text file paristhithi emo idi


[img width=900 height=675]http://i52.tinypic.com/2wpnqx5.png[/img]

[Ka NTR i]

Fixed length entho adugu baa... thappem ledhu...Nuvvemi ela load cheyalo adagadam ledhu kadha... Okkoka column ki okkokka length vuntadhi.... so adugu mee musaldhanni...

Sorry i acn't help you....I 've nevr done loading... and i am not a SQL server guy.

[charygaru]

[quote author=Ka NTR i link=topic=217792.msg2681000#msg2681000 date=1311914838]
Fixed length entho adugu baa... thappem ledhu...N uvvemi ela load cheyalo adagadam ledhu kadha... Okkoka column ki okkokka length vuntadhi. ... so adugu mee musaldhan ni...

Sorry i acn't help you....I 've nevr done loading.. . and i am not a SQL server guy.
[/quote]

fixed length ani aame annadi kaani atla pedthe kuda naaku kaavalsin a out put osthaledu  cry@fl cry@fl cry@fl cry@fl

[Nenunnanu]

boss !!! Go to columns tab there you can see the data there you have set the marker fro each column and columns are automatically created in the advanced tab. The come to advanced tab and change the column names and data types if you want. S*Mn# S*Mn# S*Mn#

[charygaru]

naa out put itla undaali mama kaani in diff diff coulmns and not a single column  , ala avvalante em cheyyalo ardham aythaldu


[img]http://i52.tinypic.com/i4odx5.png[/img]