Viewing 15 posts - 1 through 15 (of 289 total)
Jeff Moden (5/9/2015)
ScottPletcher (5/8/2015)Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??
May 13, 2015 at 1:58 pm
We use Kimball, it is all I have used. Downside is that data must input SORTED.
Sorting and aggregating are blocking functions in SSIS. this means, every...
June 27, 2014 at 2:19 pm
Do not give up! we have all had days like that (oh boy, have I...)
Just step back, take a deep breath, think about something really pleasant for a few...
June 27, 2014 at 12:45 pm
This doesn't look like a connection error to me.
Is there a script component in the flow, or is your source a text file?
Is the source component turning red...
June 27, 2014 at 12:41 pm
Yes, you can do it in derived column. what you need is a bit more cumbersome than what I would want to do in a dc, but if you...
June 23, 2014 at 2:48 pm
We have a sourcesystem table, each source is defined. We needed the ability to enable/disable sources and this accomplishes it, and leaves us a trail in case something strange...
June 6, 2014 at 1:51 pm
SSIS pkgs weren't meant for this kind of ad hoc firing. Obviously, everything depends on your unique environment, but here, an SSIS pkg could be moving gigs or terabytes...
June 2, 2014 at 2:28 pm
are you sure it's the null values triggering the error?
May 16, 2014 at 12:00 pm
I am puzzled why a date field would require itself to be named after the current date that is presumably the exact content it holds, but, not the wackiest business...
May 16, 2014 at 11:55 am
You can get around this by making your source a query that joins to that reference table.
May 16, 2014 at 10:28 am
Don't limit yourself to tech sites. If you have any special interests and are active on non-tech message boards, post there. It does seem like the questionaire is...
May 13, 2014 at 12:32 pm
May 13, 2014 at 12:30 pm
Sounds like Agent permissions. Can't tell ya much more than that as someone else here handles all config and security issues at server level.
May 13, 2014 at 12:23 pm
Congrats!! Spotting the trick questions may have grabbed that job for you as another candidate that really didn't know might have started down some path of mumbo jumbo in...
May 13, 2014 at 12:21 pm
your title says logging. after you send the email, no bother to insert a row into a table you create for the purpose of capturing things like this. ...
May 5, 2014 at 2:29 pm