Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='ChoclateBoy' timestamp='1353097945' post='1302809412'] ma anna same technology meedha working...undu vadini kanukoni cheptha.... [/quote]
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='JUJUBI_JULABI' timestamp='1353098329' post='1302809482'] database to flat file should be simple baa I mean destination format em petinav like .dat aa csv aa em format cheppu .. .dat loki dump chesi chudu .. [/quote] Direct dump cheyadaniki try chesanu baa.... Query nee oka 40 Mins run iyindi copy chestunte data chala ekuva vundi can't copy ani chupisthondi. Iyina nenu ee particular package ni night 2AM ki schdule cheyali so compulsary package rayalsindeee..
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353098586' post='1302809532'][list=1] [*]Run your query in SQL server with “Results to grid” option selected [*]Copy the output to excel [*]Select a column, right click the column header, select “column with” and set to desired length [*]Repeat for all cols [*]select File -> Save as -> Formatted text (space delimited *. csv) [*]save your file – this is your fixed record format flat file! [/list] That’s it, a little manual intervention with excel and you can easily save you data to a flatfile witouth delimiters. [/quote] But ekada oka problem vundi bhayya... This package has to run at 2AM in the morning.
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353098261' post='1302809463'] you are right bhayya i was asking him if he can export the data into excel which can hold even more data [/quote]ala antava? [quote name='JUJUBI_JULABI' timestamp='1353098329' post='1302809482'] database to flat file should be simple baa I mean destination format em petinav like .dat aa csv aa em format cheppu .. .dat loki dump chesi chudu .. [/quote] .dat lo ki kuda load cheyyocha? eppudu try cheyyaledu..ee sari eppudaina chesta [quote name='Desamudhuru' timestamp='1353098576' post='1302809530'] endaka first Excel try chesanu. Nenu using SQL 2005 so adi 97-2003(excel) matrame support chestadi. Excel 97-2003 max og 65,000 rows ante. First excel try chesi napudu Data conversions adigindi. So adi flat file ki marchina.... Now using .csv file. [/quote] aithe text file lo ki cheyyalsinde nuvvu [quote name='hpjack' timestamp='1353098586' post='1302809532'][list=1] [*]Run your query in SQL server with “Results to grid” option selected [*]Copy the output to excel [*]Select a column, right click the column header, select “column with” and set to desired length [*]Repeat for all cols [*]select File -> Save as -> Formatted text (space delimited *. csv) [*]save your file – this is your fixed record format flat file! [/list] That’s it, a little manual intervention with excel and you can easily save you data to a flatfile witouth delimiters. [/quote] results to grid pedithe .csv lo save avutundi...malli delimiters change cheskodaniki inko package raayali...ala cheyyakudadu
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353098850' post='1302809580'] But ekada oka problem vundi bhayya... This package has to run at 2AM in the morning. [/quote] asalu 180K rows ey copy ayyayai text file ki antunnav....aa text file notepad lo open chesava wordpad lo na? endukante notepad records maree huge ga unte support cheyyadu
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353099007' post='1302809608'] asalu 180K rows ey copy ayyayai text file ki antunnav....aa text file notepad lo open chesava wordpad lo na? endukante notepad records maree huge ga unte support cheyyadu [/quote] 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
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353099007' post='1302809608'] asalu 180K rows ey copy ayyayai text file ki antunnav....aa text file notepad lo open chesava wordpad lo na? endukante notepad records maree huge ga unte support cheyyadu [/quote] .csv file bhayya...
deals2buy Posted November 16, 2012 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] ya this one is good..but intha complexity lekunda simple load cheyyalema annadi naa doubt?
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353099314' post='1302809667'] .csv file bhayya... [/quote] hmm... BULK INSERT try chesava?
JUJUBI_JULABI Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353098747' post='1302809564'] Direct dump cheyadaniki try chesanu baa.... Query nee oka 40 Mins run iyindi copy chestunte data chala ekuva vundi can't copy ani chupisthondi. Iyina nenu ee particular package ni night 2AM ki schdule cheyali so compulsary package rayalsindeee.. [/quote] ade buffer ekkuva theskuntundi anukunta .. 2005 use chesi chala rojulu ayindi .. can you see the option to write the data in sets .. like 20k each time raseyadaniki .. 2008 lo aytey undi .. 2005 lo i forgot ...
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353099007' post='1302809608'] asalu 180K rows ey copy ayyayai text file ki antunnav....aa text file notepad lo open chesava wordpad lo na? endukante notepad records maree huge ga unte support cheyyadu [/quote] [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] Just now notice chesanu adi .csc anna extension tho save iyithondi baa...
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='JUJUBI_JULABI' timestamp='1353099420' post='1302809694'] ade buffer ekkuva theskuntundi anukunta .. 2005 use chesi chala rojulu ayindi .. can you see the option to write the data in sets .. like 20k each time raseyadaniki .. 2008 lo aytey undi .. 2005 lo i forgot ... [/quote] Yeah bhayya 2005 lo adi ledu 2008 lo vundi.
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353099369' post='1302809680'] hmm... BULK INSERT try chesava? [/quote] Ledu bhayya adi how ??
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353099473' post='1302809701'] Just now notice chesanu adi .csc anna extension tho save iyithondi baa... [/quote] hmm..whatever extension may be? SSIS lo bulk insert ane work flow untundi anukunta kadaa?
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353099536' post='1302809715'] Ledu bhayya adi how ?? [/quote] 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
Recommended Posts