Timeline for Fixed length text file insert into SQL table
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2013 at 13:27 | comment | added | SQLFox | In my very limited experience, SQL isn't as bad at string manipulation as everyone says--this is how I'd try it if SSIS vaporized itself, and if the performance wasn't acceptable, I'd try something else. | |
| May 16, 2013 at 8:01 | comment | added | Roi Gavish |
Using substring() to split millions of rows is a performance disaster. Take a look at my answer using FORMAT FILE, isn't it a better solution for his situation?
|
|
| May 15, 2013 at 13:59 | history | answered | SQLFox | CC BY-SA 3.0 |