Hmm... good point, but...

but thinking more of user-supplied list of values (like, say, an SSRS report, that passes the parameter to a stored proc to get the data for...

Hmm... I kind of like the XML-based splitter method, if only because part of the process is it can throw out the data in the output tableset as a specific...

That being said, I'm using Powershell + EPPlus + SQLPS to push data into a .xlsx file, and simply use SSIS as the process control layer. Seems to work OK...

There is a 64-bit version of the Access Database engine, as well as 32-bit. On a 64-bit computer, both seem to coexist OK. But only if you don't have...

even then, may throw an error trying to cast classname = 'Math' to an int as well...

look into https://excelpslib.codeplex.com/

To do that, use the ExcelPSLib .Net library (https://excelpslib.codeplex.com/). This library manipulates data into the OOXML format, which Excel can then read as if it was a native file.

Excel really...

the average developer will flip out when they have to add a new table field into an SSIS package. But, it seems some people really like feeling "good" at all...

the gac util will be in the Microsoft.Net framework file (C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe)

there is 64-bit ACE engine now, too.

But, don't install 32-bit ACE *and* 64-bit ACE on same server. They interfere with each other (been there, done that).

Especially don't do this...

Hmm... if it was truly Undocumented and Verboten, MS would've made it an obscure dbcc call, an extended proc, etc. Instead, it's definition is there, in the clear.

It's...

google psdoom

there was a bored Unix sysadmin back in the late 90's who managed to cob up a Doom WAD that would represent server processes in Doom, in various guises/monsters, depending...

Yeah, you really want to have your SMK and DMK's in more than one place and media. You're SOL w/o a paddle or a canoe, at different levels (SMK vs...

Hmm... not too hard to do a small bit of googling (or better, searching on sqlservercentral.com) for how to ingest an XML file into a xml variable using TSQL instead.

Once...