Sql Server Data Insert Gurunchi Doubt ?

[mtkr]

[quote name='littlemoon' timestamp='1355951035' post='1302982900']
but conditions chk cheyaliii 1st ... persons koni rows values check cheyaliii
[/quote]

frst ne SP ela wrk avutundhiii...?


like adi source data ni two tables tho compare chesi data ni tabl 1 loki load chestundaa??

or two tables lo data ni direct ga tbl 1 loki load chestundaaa!! wth conditions??

[mtkr]

[quote name='Desamudhuru' timestamp='1355951175' post='1302982922']
mama ardham kale.
[/quote]


adte data ni web pages laga chupistunnammm kani ekkada load cheyyadam ledhu gaaa!!!

[littlemoon]

[quote name='mtkr' timestamp='1355951314' post='1302982938']

frst ne SP ela wrk avutundhiii...?


like adi source data ni two tables tho compare chesi data ni tabl 1 loki load chestundaa??

or two tables lo data ni direct ga tbl 1 loki load chestundaaa!! wth conditions??
[/quote]
2 tables compare chesi load cheshtundi

[littlemoon]

[quote name='Desamudhuru' timestamp='1355951064' post='1302982907']
ee pain question ki reply evu
[/quote]
FTP enti naku ardham kaledhu

we are getting it from a internal tool to which tht DB is connected

[mtkr]

[quote name='littlemoon' timestamp='1355951526' post='1302982968']
2 tables compare chesi load cheshtundi
[/quote]


server 2 tbl ni source laaga use chesukovadam kudaradhaaa SP lo??

[mtkr]

[quote name='littlemoon' timestamp='1355950547' post='1302982813']
kadhu server 1 oka tool thru update avthundi

server 2 lo ma website thru update avthundi and idhi major ga updating ...
[/quote]

server 1 lo loading ela avutundhiii???

[littlemoon]

[quote name='mtkr' timestamp='1355952093' post='1302983045']
server 1 lo loading ela avutundhiii???
[/quote]
edi aithe internal tool anano andulo users can call our CSR and update their preferences... and tool server 1 Db connect ayi undi so akada data update avthundi

[Desamudhuru]

[quote name='littlemoon' timestamp='1355951641' post='1302982978']
FTP enti naku ardham kaledhu

we are getting it from a internal tool to which tht DB is connected
[/quote]
select ( condition) ----->
then push that table into a flatfile......
then push that flat file into Server 1 table XX.....


Create a package and the data can be pushed easily.

[littlemoon]

[quote name='Desamudhuru' timestamp='1355952345' post='1302983082']
select ( condition) ----->
then push that table into a flatfile......
then push that flat file into Server 1 table XX.....


Create a package and the data can be pushed easily.
[/quote]
flat file ante SSIS pkg create chesa??

[Desamudhuru]

[quote name='littlemoon' timestamp='1355952512' post='1302983102']
flat file ante SSIS pkg create chesa??
[/quote]
Yes

[littlemoon]

[quote name='Desamudhuru' timestamp='1355952585' post='1302983108']
Yes
[/quote]
SSIS ssrs levu ... asalu 1st e chepanu kada

[mtkr]

[quote name='littlemoon' timestamp='1355952263' post='1302983068']
edi aithe internal tool anano andulo users can call our CSR and update their preferences... and tool server 1 Db connect ayi undi so akada data update avthundi
[/quote]


neeku aaa tool ki access undhaa??
n aa user preferneces ento telusa neek??

[mtkr]

[quote name='littlemoon' timestamp='1355952667' post='1302983121']
SSIS ssrs levu ... asalu 1st e chepanu kada
[/quote]


assal meek server 1 ki nad server 2 ki data ekkadi nundi vastundhiii???
n aaa servers lo ela load chesthunnaruuu???

[Desamudhuru]

[quote name='littlemoon' timestamp='1355952667' post='1302983121']
SSIS ssrs levu ... asalu 1st e chepanu kada
[/quote]


Server2 mida condition tho voche O/P ni oka table loki store cheyi.


Ni server2 nundi server1 ki data fush cheyali ante

Server 2 mida ni DB mida right click chesi Tasks---> export data-----> source and destination select cheyu.....

At the end save as /Run immediately ani vosthadi in that run immediately ani select cheste data gets stored in table XX

edi right now data ni push cheya daniki but be carefull jagrathaga cheyi.

schedule cheyali ante ...... chudali.

[Robinhood1676]

write the insert statement or use the SP sql and import data using import and export tool and past that query in that tool without selecting tables....