Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353099233' post='1302809654'] 200k rows tarvata quit ayyi --> next flat file loki move avvali then 200k load chesi--->migita 50k rows third csv file loki move avvali naming the filenames like csv11162011_1 .csv, csv11162011_2 .csv, csv11162011_3 .csv konchem dynamic undali package... will also searrch and let u know [/quote] Thanks bhayya kani edaka inkoka twist kuda vundi.................................................... ala data motham load iyina file ni data uploader tho vunna data motham website loki upload cheyali.
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353099608' post='1302809732'] adi T-SQL use chesi run chestaav...but nee daggara rows ekkuva unnayi kadaa maree..handle chestundo ledo BULK INSERT lo nuvvu oka format file create cheskovali malli [/quote] Anta depth ga ante teliyadu. Monnane chepa kada Pirst job ani koncham ardham chesuko bhayya clear ga chepthava
ravula Posted November 16, 2012 Report Posted November 16, 2012 example BULK INSERT pubs..publishers2 FROM 'c:\newpubs .dat' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353099824' post='1302809769'] example BULK INSERT pubs..publishers2 FROM 'c:\newpubs .csv' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) [/quote] oka execute sql task lo paina code vesi chudu
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353100077' post='1302809816'] oka execute sql task lo paina code vesi chudu [/quote] Acutally adi ardham kaledu baa adi enduku asalu ??
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353100221' post='1302809850'] Acutally adi ardham kaledu baa adi enduku asalu ?? [/quote] ante we are trying different options here to resolve the issue idi work avtada leda ani try chestunnam ante
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353099697' post='1302809748'] Anta depth ga ante teliyadu. Monnane chepa kada Pirst job ani koncham ardham chesuko bhayya clear ga chepthava [/quote] similar to the below code [quote name='hpjack' timestamp='1353099824' post='1302809769'] example BULK INSERT pubs..publishers2 FROM 'c:\newpubs .dat' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) [/quote] this will not work in all the cases... Database nundi anni columns kanuka Flat File ki load cheyyakapothe, the above code fails...alantappudu oka Format File create cheskovaali...daani syntax ila untadi [CODE] INSERT SampleDB.dbo.SampleTable FROM 'C:\TextFiles\sample.txt' WITH (FORMATFILE = 'C:\sample.fmt') [/CODE]
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353100333' post='1302809872'] ante we are trying different options here to resolve the issue idi work avtada leda ani try chestunnam ante [/quote] Ok vesi chuste em vosthadi ani ni idea ??
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353100077' post='1302809816'] oka execute sql task lo paina code vesi chudu [/quote]
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353100389' post='1302809885'] Ok vesi chuste em vosthadi ani ni idea ?? [/quote] data move avtadi from sql server to csv file
gundugadu Posted November 16, 2012 Report Posted November 16, 2012 baaaa bulk copy protocol vuntundi its pretty easy [color=#37414B]bcp {dbtable | query} queryout } datafile[/color] [color=#37414B][-n native type] [-c character type] [-S server name] [-U username][/color] [color=#37414B][-P password] [-T trusted connection][/color]
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='gundugadu' timestamp='1353100676' post='1302809946'] baaaa bulk copy protocol vuntundi its pretty easy [color=#37414B]bcp {dbtable | query} queryout } datafile[/color] [color=#37414B][-n native type] [-c character type] [-S server name] [-U username][/color] [color=#37414B][-P password] [-T trusted connection][/color] [/quote] ya this one is a good option too
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='gundugadu' timestamp='1353100676' post='1302809946'] baaaa bulk copy protocol vuntundi its pretty easy [color=#37414B]bcp {dbtable | query} queryout } datafile[/color] [color=#37414B][-n native type] [-c character type] [-S server name] [-U username][/color] [color=#37414B][-P password] [-T trusted connection][/color] [/quote] nenu table nundi kadu baa oka view nundi data thisukuntuna. So edi ela rayali ??
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353100867' post='1302809982'] nenu table nundi kadu baa oka view nundi data thisukuntuna. So edi ela rayali ?? [/quote] table/view all same objects mama..when u r trying to load into them aithe diff vastundi kaani ..when u trying to load out of them em problem raadu
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='gundugadu' timestamp='1353100676' post='1302809946'] baaaa bulk copy protocol vuntundi its pretty easy [color=#37414B]bcp {dbtable | query} queryout } datafile[/color] [color=#37414B][-n native type] [-c character type] [-S server name] [-U username][/color] [color=#37414B][-P password] [-T trusted connection][/color] [/quote] Code ekada edi rayalo help cheyava baa.... i mean for example okati veyandi edo oka real time scrnario thisukoni... And also ekada rayali ????. Help ithundi baa....And also ee bulk copy ni schdule cheyavochaa ??
Recommended Posts