cool_dude Posted April 7, 2015 Author Report Posted April 7, 2015 http://stackoverflow.com/questions/16945348/excel-csv-file-with-more-than-1-048-576-rows-of-data use avutunda Check this https://social.msdn.microsoft.com/Forums/sqlserver/en-US/283e3100-73b0-4cd8-b8f2-f31fb55eed5d/export-data-from-sql-server-to-excel-without-excel-sheet-constraint?forum=sqlintegrationservices Thank you for the links guys. Chusanu ivvi. But as told they want the data as in one sheet instead of splitting the data.
pythonic Posted April 7, 2015 Report Posted April 7, 2015 Thank you for the links guys. Chusanu ivvi. But as told they want the data as in one sheet instead of splitting the data. Ayithe nuvvu flat file loki import cheyali man...excel 2007 lo limitation anta adhi...
suryausa Posted April 7, 2015 Report Posted April 7, 2015 Ayithe nuvvu flat file loki import cheyali man...excel 2007 lo limitation anta adhi... +1
cool_dude Posted April 7, 2015 Author Report Posted April 7, 2015 Ayithe nuvvu flat file loki import cheyali man...excel 2007 lo limitation anta adhi... Anduke CSV lo import chesanu bhaiyya. But to open the CSV it opens as MS Office Excel Comma Seperated Values , so 1048576 rows chupistunnayi. SSIS package execute aytunappudu it showed that 6271585 rows reflected ani.
dotnet_developer Posted April 7, 2015 Report Posted April 7, 2015 Anduke CSV lo import chesanu bhaiyya. But to open the CSV it opens as MS Office Excel Comma Seperated Values , so 1048576 rows chupistunnayi. SSIS package execute aytunappudu it showed that 6271585 rows reflected ani. May be u didnt get my point..ne doubt clarify cheskodanki..SSIS package tho execute aina file size chudu..nu antuna 1048576 rows only vere excel lo petti dhani size chudu..rendu match aite SSIS tho generate aina file lo kuda 1048576 rows eh unatu..lekpothe dhantlo 6 mil rows unatu..in that case u can send the file to ur customer
cool_dude Posted April 8, 2015 Author Report Posted April 8, 2015 May be u didnt get my point..ne doubt clarify cheskodanki..SSIS package tho execute aina file size chudu..nu antuna 1048576 rows only vere excel lo petti dhani size chudu..rendu match aite SSIS tho generate aina file lo kuda 1048576 rows eh unatu..lekpothe dhantlo 6 mil rows unatu..in that case u can send the file to ur customer Tnq bhaiyya. May be u r right. Ala chesanu dude. Rendu file sizes different vastunnayi. But confirmation kosam I am importing the whole table data from txt to sql server. Will see how data comes.
DaleSteyn1 Posted April 8, 2015 Report Posted April 8, 2015 Tnq bhaiyya. May be u r right. Ala chesanu dude. Rendu file sizes different vastunnayi. But confirmation kosam I am importing the whole table data from txt to sql server. Will see how data comes.ms access vaadthara vallu oka vela aithe adhi best vallaki
dotnet_developer Posted April 8, 2015 Report Posted April 8, 2015 Tnq bhaiyya. May be u r right. Ala chesanu dude. Rendu file sizes different vastunnayi. But confirmation kosam I am importing the whole table data from txt to sql server. Will see how data comes. Cool dude
Recommended Posts