Darling999 Posted March 21, 2013 Report Share 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. Link to comment Share on other sites More sharing options...
loveindia Posted March 21, 2013 Report Share 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.. Link to comment Share on other sites More sharing options...
Darling999 Posted March 21, 2013 Report Share 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..? Link to comment Share on other sites More sharing options...
loveindia Posted March 21, 2013 Report Share 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... Link to comment Share on other sites More sharing options...
flavours Posted March 21, 2013 Report Share 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.... Link to comment Share on other sites More sharing options...
flavours Posted March 21, 2013 Report Share 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 Link to comment Share on other sites More sharing options...
loveindia Posted March 21, 2013 Report Share 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... Link to comment Share on other sites More sharing options...
flavours Posted March 21, 2013 Report Share Posted March 21, 2013 [quote name='loveindia' timestamp='1363881778' post='1303462829'] youtube lo shame to shame requirement meeda tutorial untadi.. chudamani cheppu... [/quote] vokay...... Link to comment Share on other sites More sharing options...
deals2buy Posted March 21, 2013 Report Share 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] Link to comment Share on other sites More sharing options...
loveindia Posted March 21, 2013 Report Share 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.... Link to comment Share on other sites More sharing options...
deals2buy Posted March 21, 2013 Report Share 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] Link to comment Share on other sites More sharing options...
vizagpower Posted March 21, 2013 Report Share 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 Link to comment Share on other sites More sharing options...
deals2buy Posted March 25, 2013 Report Share 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] Link to comment Share on other sites More sharing options...
loveindia Posted March 25, 2013 Report Share 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] Link to comment Share on other sites More sharing options...
deals2buy Posted March 25, 2013 Report Share 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 Link to comment Share on other sites More sharing options...
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts