Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
8022421
Starting Member
45 Posts |
 Posted - 2009-10-21 : 03:20:24
|
| I have table containing 7 million rows, I want to extract these data to a excel file. Is there any easy approach to extract the same in SSIS. Thanks in Advance.. |
|
|
gaauspawcscwcj
Starting Member
29 Posts |
Posted - 2009-10-21 : 03:27:14
|
| can't understand ???are u mean how to use SSIS to extract to excel ???gaauspawcscwcj |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-21 : 04:12:56
|
| Do you want to export data of all 7 million to EXCEL?Which version of EXCEL are you using?MadhivananFailing to plan is Planning to fail |
|
|
|
8022421
Starting Member
45 Posts |
Posted - 2009-10-21 : 04:59:43
|
| Ya.. I just want to extract all the 7 million rows to excel using ssis. I am using office 2007. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-21 : 05:12:25
|
quote:
Originally posted by 8022421
Ya.. I just want to extract all the 7 million rows to excel using ssis. I am using office 2007.
I doubt if EXECL 2007 will allow you to have more than 1 million rowsWhy do you want to export all data?MadhivananFailing to plan is Planning to fail |
|
|
|
8022421
Starting Member
45 Posts |
Posted - 2009-10-21 : 05:21:40
|
| It won't allow to insert these number of rows.. Client wants a report in excel for the data that is migrated from one system to another system. |
|
|
|
|
|
|
Extract to Excel.