Desamudhuru Posted November 16, 2012 Report Posted November 16, 2012 Friends Database lo vunna data ni flat files lo petali. it has 450K rows adi oka VIEW. Package1: Direct ga data load cheya daniki try chesanu kaledu. Anta data copy cheyalenu annadhi. 2 : SSIS package okati rasi danni direct Flat file ki send chestuna data ni. Its going kani 200K rows tharvatha Task Completed ani chupisthondi em error chupiyadam ledu. 3 : SSIS package rasanu SQL destination peti Oka table create chesi dani loki data send chesanu..... Adi emo 175K rows degara agi poyindi..... All the above i'm doing in SQL server 2005 Ee paina given ways kakunda inka emaina kothavi vunte chepagalara plzzz.....
Darling999 Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353096949' post='1302809231'] Friends Database lo vunna data ni flat files lo petali. it has 450K rows adi oka VIEW. Package1: Direct ga data load cheya daniki try chesanu kaledu. Anta data copy cheyalenu annadhi. 2 : SSIS package okati rasi danni direct Flat file ki send chestuna data ni. Its going kani 200K rows tharvatha Task Completed ani chupisthondi em error chupiyadam ledu. 3 : SSIS package rasanu SQL destination peti Oka table create chesi dani loki data send chesanu..... Adi emo 175K rows degara agi poyindi..... All the above i'm doing in SQL server 2005 Ee paina given ways kakunda inka emaina kothavi vunte chepagalara plzzz..... [/quote] package soosety ventaney cheptaa mama Issue nee Dataflow properties lo default settings untaayi. Flat file nunchi antha Data velladu ankuntaa table ki. Oka saari msdn forums lo opst cheyyi ee dout answer vastadi ventaey
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='DARLING...' timestamp='1353097264' post='1302809305'] package soosety ventaney cheptaa mama Issue nee Dataflow properties lo default settings untaayi. Flat file nunchi antha Data velladu ankuntaa table ki. Oka saari msdn forums lo opst cheyyi ee dout answer vastadi ventaey [/quote] Database nundi Flat file ki velali bhayya
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 confuse chesav Database to Flat File veltunnava leka Flat file to database aa?
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353097743' post='1302809381'] Database nundi Flat file ki velali bhayya [/quote] ok...indaaka vere thread lo evo data conversion chestunna annv madhyalo? enduku?
ravula Posted November 16, 2012 Report Posted November 16, 2012 flat file ante em file? .txt aa ? .csv aa? excel as destination try chesava?
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353097886' post='1302809404'] flat file ante em file? .txt aa ? .csv aa? excel lo try chesava? [/quote] flatfile destination kuda untundi kadaa? excel enduku madhyalo?
bokuboy Posted November 16, 2012 Report Posted November 16, 2012 ma anna same technology meedha working...undu vadini kanukoni cheptha....
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353097939' post='1302809410'] flatfile destination kuda untundi kadaa? excel enduku madhyalo? [/quote] OP said he is moving data from sql server to flat file kada so i was asking him what is the flat file? is it .txt, csv or what exactly it is ani
deals2buy Posted November 16, 2012 Report Posted November 16, 2012 [quote name='hpjack' timestamp='1353098090' post='1302809431'] OP said he is moving data from sql server to flat file kada so i was asking him what is the flat file? is it .txt, csv or what exactly it is ani [/quote] .txt or .csv rendikti flat file destination ey use chestaam kadaa? .xls aithe excel destination use chestaam kadaa? correct me if I am wrong
ravula Posted November 16, 2012 Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353098153' post='1302809440'] .txt or .csv rendikti flat file destination ey use chestaam kadaa? .xls aithe excel destination use chestaam kadaa? correct me if I am wrong [/quote] you are right bhayya i was asking him if he can export the data into excel which can hold even more data
JUJUBI_JULABI Posted November 16, 2012 Report Posted November 16, 2012 [quote name='Desamudhuru' timestamp='1353096949' post='1302809231'] Friends Database lo vunna data ni flat files lo petali. it has 450K rows adi oka VIEW. Package1: Direct ga data load cheya daniki try chesanu kaledu. Anta data copy cheyalenu annadhi. 2 : SSIS package okati rasi danni direct Flat file ki send chestuna data ni. Its going kani 200K rows tharvatha Task Completed ani chupisthondi em error chupiyadam ledu. 3 : SSIS package rasanu SQL destination peti Oka table create chesi dani loki data send chesanu..... Adi emo 175K rows degara agi poyindi..... All the above i'm doing in SQL server 2005 Ee paina given ways kakunda inka emaina kothavi vunte chepagalara plzzz..... [/quote] 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 ..
Desamudhuru Posted November 16, 2012 Author Report Posted November 16, 2012 [quote name='deals2buy' timestamp='1353097821' post='1302809394'] ok...indaaka vere thread lo evo data conversion chestunna annv madhyalo? enduku? [/quote] [quote name='hpjack' timestamp='1353097886' post='1302809404'] flat file ante em file? .txt aa ? .csv aa? excel as destination try chesava? [/quote] 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.
ravula Posted November 16, 2012 Report Posted November 16, 2012 [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.
Recommended Posts