Darling999 Posted March 21, 2013 Report Posted March 21, 2013 [quote name='flavours' timestamp='1363879650' post='1303462528'] help for my friend......1st proj (non-tech bkgrnd)......... [color=#000000][font=arial, sans-serif][size=3]create a job to copy tables from one sql server to the other and then copy it to the oracle db.[/size][/font][/color] [color=#000000][font=arial, sans-serif][size=3]google chesthe evo evo vasthunayi....nadhi sql server tech kaadu.....telisins experts please help cheyandi.......[/size][/font][/color] [/quote] Create a Job antey SQL lo job aah lekaa SSIS(SQL BI tool) enduloo cheyyali cheppu we can give an idea. Its Very Easy task tell him not to worry.
loveindia Posted March 21, 2013 Report Posted March 21, 2013 [quote name='flavours' timestamp='1363879650' post='1303462528'] help for my friend......1st proj (non-tech bkgrnd)......... [color=#000000][font=arial, sans-serif][size=3]create a job to copy tables from one sql server to the other and then copy it to the oracle db.[/size][/font][/color] [color=#000000][font=arial, sans-serif][size=3]google chesthe evo evo vasthunayi....nadhi sql server tech kaadu.....telisins experts please help cheyandi.......[/size][/font][/color] [/quote] DTS import export ani okati untadi.. use that and at the end, it will say save job.. future ki panikostadi.. inka sophisticated ga kaavali antey SQL Job / SSIS better.. first suggestion is for onetime or eppudaina use kosam.. repeated kosam waste..
Darling999 Posted March 21, 2013 Report Posted March 21, 2013 [quote name='loveindia' timestamp='1363880506' post='1303462641'] DTS import export ani okati untadi.. use that and at the end, it will say save job.. future ki panikostadi.. inka sophisticated ga kaavali antey SQL Job / SSIS better.. first suggestion is for onetime or eppudaina use kosam.. repeated kosam waste.. [/quote] Hi rey How Are you..?
loveindia Posted March 21, 2013 Report Posted March 21, 2013 [quote name='DARLING...' timestamp='1363881170' post='1303462730'] Hi rey How Are you..? [/quote] I am good rey... bayata post esa.. dekha kya...
flavours Posted March 21, 2013 Report Posted March 21, 2013 [quote name='loveindia' timestamp='1363880506' post='1303462641'] DTS import export ani okati untadi.. use that and at the end, it will say save job.. future ki panikostadi.. inka sophisticated ga kaavali antey SQL Job / SSIS better.. first suggestion is for onetime or eppudaina use kosam.. repeated kosam waste.. [/quote] ok...thanks bhayya chepthanu....
flavours Posted March 21, 2013 Report Posted March 21, 2013 [quote name='loveindia' timestamp='1363880506' post='1303462641'] DTS import export ani okati untadi.. use that and at the end, it will say save job.. future ki panikostadi.. inka sophisticated ga kaavali antey SQL Job / SSIS better.. first suggestion is for onetime or eppudaina use kosam.. repeated kosam waste.. [/quote] kaani sql job ante re-use kosam kada bhayya..... sql job ela rastharu?? i mean any tutorial
loveindia Posted March 21, 2013 Report Posted March 21, 2013 [quote name='flavours' timestamp='1363881536' post='1303462793'] kaani sql job ante re-use kosam kada bhayya..... sql job ela rastharu?? i mean any tutorial [/quote] youtube lo shame to shame requirement meeda tutorial untadi.. chudamani cheppu...
flavours Posted March 21, 2013 Report Posted March 21, 2013 [quote name='loveindia' timestamp='1363881778' post='1303462829'] youtube lo shame to shame requirement meeda tutorial untadi.. chudamani cheppu... [/quote] vokay......
deals2buy Posted March 21, 2013 Report Posted March 21, 2013 [quote name='GatisKandis' timestamp='1363875077' post='1303462082'] xml documents meda neeku paga [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] [/quote] naa jeevitham lo okkasari kuda xml document chudaledu [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
loveindia Posted March 21, 2013 Report Posted March 21, 2013 [quote name='Kaarthikeya' timestamp='1363884077' post='1303463105'] naa jeevitham lo okkasari kuda xml document chudaledu [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] [/quote] neekosamey SQL with XML post esa bhakthaa....
deals2buy Posted March 21, 2013 Report Posted March 21, 2013 [quote name='loveindia' timestamp='1363889485' post='1303463507'] neekosamey SQL with XML post esa bhakthaa.... [/quote] thanks devuda [img]https://lh6.googleusercontent.com/-iuNYcTr3WhQ/TY1c4JQQQ4I/AAAAAAAAC48/17ZdBPcjwKM/s160/RT%2520tku.gif[/img]
vizagpower Posted March 21, 2013 Report Posted March 21, 2013 [quote name='eela' timestamp='1363879327' post='1303462492'] Na Paleru job vundhi kadha...[img]http://www.bewarsetalk.net/discus/movieanimated3/bemmi.lol1.gif[/img][img]http://www.bewarsetalk.net/discus/movieanimated3/bemmi.lol1.gif[/img] [/quote] msbi or ssis/ sql threads unte aalinks pm cheyandi pin chesukunta please
deals2buy Posted March 25, 2013 Report Posted March 25, 2013 T-SQL experts come here... naa daggara oka text file undi and it has data....and aa data lo oka column lo say for example: KitKat and DairyMilk ani undi.. ippudu nenu aa file lo unna anni columns tho paatu paina cheppina column lo only DairyMilk unna columns ne extract chesi vere file lo padeyyali...adi ela chestaro telusa evarikaina? Also, to be specific aa file comma delimiter tho undi [color=#ff0000]PS: I need to use only T-SQL to do this....and no Database Tables....[/color]
loveindia Posted March 25, 2013 Report Posted March 25, 2013 [quote name='Kaarthikeya' timestamp='1364225660' post='1303483901'] T-SQL experts come here... naa daggara oka text file undi and it has data....and aa data lo oka column lo say for example: KitKat and DairyMilk ani undi.. [size=6]ippudu nenu aa file lo unna anni columns tho paatu paina cheppina column lo only DairyMilk unna columns ne extract chesi vere file lo padeyyali...adi ela chestaro telusa evarikaina?[/size] Also, to be specific aa file comma delimiter tho undi [color=#ff0000]PS: I need to use only T-SQL to do this....and no Database Tables....[/color] [/quote] BULK IMPORT / EXPORT aa option aa vaadu.. but asalu table loki import cheykunda text file ni em chestaav... or else use DTS IMPORT EXPORT WIZARD. source flat file / destination flat file. instead of direct write.. query vaadi teeskoni ra data ni neeeku ela kaavalo ala.... [size=6]ardam kaaledu sarigga explain cheyyi scenario.. with some test data is good...[/size]
deals2buy Posted March 25, 2013 Report Posted March 25, 2013 [quote name='loveindia' timestamp='1364227134' post='1303484000'] BULK IMPORT / EXPORT aa option aa vaadu.. but asalu table loki import cheykunda text file ni em chestaav... or else use DTS IMPORT EXPORT WIZARD. source flat file / destination flat file. instead of direct write.. query vaadi teeskoni ra data ni neeeku ela kaavalo ala.... [size=6]ardam kaaledu sarigga explain cheyyi scenario.. with some test data is good...[/size] [/quote] nuvvu cheppinavanni possible kaaledane ikkada post chesa bhayya sare the data in txt file looks something like this: 1, Kaarthikeya, India, CreditCard, Purchased Dairy Milk Product, $3.00 2, deals2buy, USA, DebitCard, Purchased Orange Chutney, $100.00 aa paina data lo delimiter vachesi "," (comma)...daani batti neeku avanni fields ani ardhamayuntundi... ippudu oka customer oka location lo oka product kontaadu...aa product konnappudu aa product name tho last but one column update avutundi....say if u buy Bataanilu, then the column would be updated as 'Purchaes Bataanilu' so nenu text file ni motham line by line or as a whole read chesi 'Purchased Dairy Milk Product' ani unna rows anni exclude chesi remaining rows ni inko file lo load cheyyali.... and mundu cheppinattu idantha T-SQL use chesi matrame cheyyali
Recommended Posts