What I have are about 180 managers at varying levels within the Parent Child Employee dimension.  I was hoping there was a way to create a single role that I...

If you really have massive numbers of files, I'd recommend going with CozyRoc's Paralell Execution Task step instead.

https://www.cozyroc.com/ssis/parallel-loop-task

Instead of having to spawn multiple independent tasks that all run separately in...

No they haven't... at least not as of SQL 2016

IDENTITY / SEQUENCE will always be the fastest because the keys are smallest and in sequential order.

If you must use a GUID use NEWSEQUENTIALID() because the keys will...

That's pretty much what I did... and slapped a Distinct Count base measure on the composite value.

I was wondering if there was a better solution.

I'd recommend using Cozyroc for this.  The Data Flow+ Task SSIS component has the capability to dynamically map columns on the fly

Jeff Moden (9/16/2016)

---

That's certainly a part of my point, though. Why even bother disabling it? Who's going to use it when it's enable? The answer is, only...

Daario (3/29/2016)

---

This is another thing you may want to do upon setup:

ALTER DATABASE [SSISDB] SET RECOVERY SIMPLE;

The transaction log can get a bit unruly, and Point-in-time recovery has limited usefulness...

And thanks to Ben for the tip about permissions.

In my environments we just blanket grant sa privileges for running the maintenance scripts like this and syspolicy_purge_history so it slipped by...

I completely agree... when I look at some of my jobs lists... I get lost trying to identify what I'm looking for.

Let's not even get into SSRS Subscription schedules.... Nothing...

Koen Verbeeck (2/11/2014)

---

I get that SSIS can only do data dumps to Excel and that if you want nicely formatted Excel files you either use a library - like in...

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a bit of a...

Steve Hendricks (1/14/2016)

---

I cry foul!!! As James Lean has pointed out, the INFORMATION_SCHEMA.ROUTINES returns both stored procedures AND functions!!! Without the additional filtering, it would be analogous to saying that...

Excellent article.

Typically I'd just use the delimitted splitter to break the string up, and then figure out a way to put it all back together somehow.

For smaller strings...

Use an Expression task to assign it

Then just put the variable in the expression followed by an equals sign followed by the paramter