Viewing 15 posts - 1 through 15 (of 1,033 total)
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...
April 23, 2020 at 5:44 pm
If you really have massive numbers of files, I'd recommend going with CozyRoc's Paralell Execution Task step instead.
Instead of having to spawn multiple independent tasks that all run separately in...
August 23, 2019 at 10:42 am
No they haven't... at least not as of SQL 2016
January 11, 2019 at 6:57 am
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...
December 27, 2018 at 7:15 am
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.
August 7, 2018 at 8:31 am
I'd recommend using Cozyroc for this. The Data Flow+ Task SSIS component has the capability to dynamically map columns on the fly
June 13, 2018 at 2:50 pm
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...
September 16, 2016 at 12:26 pm
ALTER DATABASE [SSISDB] SET RECOVERY SIMPLE;
The transaction log can get a bit unruly, and Point-in-time recovery has limited usefulness...
March 29, 2016 at 8:34 am
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...
March 29, 2016 at 8:11 am
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...
March 29, 2016 at 7:05 am
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...
January 22, 2016 at 9:44 am
Eirikur Eiriksson (1/12/2016)
January 15, 2016 at 7:42 am
Steve Hendricks (1/14/2016)
January 15, 2016 at 7:14 am
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...
January 15, 2016 at 6:57 am
Use an Expression task to assign it
Then just put the variable in the expression followed by an equals sign followed by the paramter
September 17, 2015 at 1:03 pm