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 - 2011-03-21 : 06:35:54
|
| Hi,I have a table which holds 150 million records, we are requested to load the data to a flat file. what we did was we had a OLEDB source and a flat file destination. But it took more than 3 days to complete the processing. Can I improve the perfomance in this scenario, or is there a alrenative way that I can reduce the time duration.Please do help me in this.ThanksDhana |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Load 150 million records to flat file.