Timeline for TSQL vs SSIS Lookup
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 24, 2014 at 13:46 | comment | added | RLF | No, BULK INSERT only reads from files, but I added some updates on reasons to consider that. And, as you mentioned, you can control the batches yourself by creating code to loop through the selects. | |
| Nov 24, 2014 at 13:44 | history | edited | RLF | CC BY-SA 3.0 |
Added clearer explanation, briefly discussed looping through the code.
|
| Nov 24, 2014 at 7:27 | comment | added | OverflowStack | Is it possible to do bulk insert from a view (or table) to a table? I thought it was only possible from csv. How would that look like syntaxwise? I am aware of the INSERT ... SELECT * FROM OPENROWSET(BULK ...) statement. However in that syntax you are not able to use KB per batch. | |
| Nov 24, 2014 at 0:06 | history | edited | RLF | CC BY-SA 3.0 |
spelling
|
| Nov 23, 2014 at 22:41 | history | answered | RLF | CC BY-SA 3.0 |