I suggest looking into SqlBulkCopy with a DataTable.

Huge thanks for this, have run into the memory limitation before.

I would just add as a caveat that having unrelated jobs sharing a schedule can have unintended consequences when you think you are changing a schedule for one, but it...

If anyone else runs into issues with this, I believe that the order you install things matters. I was able to get a working R install by going in the...

Thanks very much for the head's up.

I have installed CTP 3, and followed the MS instructions for enabling R (including the other installers), but I'm hitting a brick wall when...

Good tip, thanks!

(in reply to post about using OFFLINE instead of SINGLE_USER)

Very cool, thanks for this.

Thank you, that would explain it!

manub22 (6/16/2015)

---

"R" was not part of CTP2 release of SQL Server 2016.

It might be coming with the CTP3 release or with the RTM, and followed...

Thanks, posted there.

I would suggest making sure you are using bulk inserts with batch sizes and max commits (e.g. smaller transactions => less transaction space needed for the operations). In SSIS, these...

Yes, see knowledge base article here:

http://support.microsoft.com/kb/2874903

I suspect that only Microsoft can answer this mystery.

I've only seen it once a day, but on multiple VMs.

This was happening with sql 2012 SP1 and then after I upgraded to SP2 + CU3.

Nothing is breaking, but then...

Correct, that has been ruled out.

Well, thanks for looking into this, anyway, I appreciate it.

And, my mistake, it was SQL Saturday in Miami that I saw your presentation!