SSIS Annotation
-
I just wrote an annotation in a data flow in SSIS. When entering a date in the format 'DD-MM-YYYY' (dutch default notation) I automatically used the minus-key located on the numpad. No hyphen appeared. Used the other one and bingo. Opened Notepad to verify that the numpad-minus was working. It was...
SSIS discriminates between numpad and regular hyphen when entering annotations. Debate.
-
Maybe it's filtering based on key code, instead of key character. Still a WTF though as (as far as I understand from your post) SSIS accepts both numbers from the key pad and the regular ones in the top row of the alphanumeric keyboard section, but they forgot to do the same thing for the hyphen-key. So sue them.
-
It was a hot day in Alaska, and Tonuguelli trudged into the office in just 3 layers of clothing. Things were getting out of hand with this global warming thing, but as a lowly oil drill management software developer, there was very little he could do about it. He hung his coat on the peg and fixed himself a cup of coffee before sitting down to work. Within minutes, a fresh email from their dutch office came in.
"Total system failure! CRITICAL!" was the subject line, oh dear, Tonuguelli knew their dutch data centre had woefully inadequate surge protection and it was only a matter of time before it came back to bite them. It seemed like time was finally up, a lightning strike must have caused a power surge and fried half the servers. He opened the email and read on, expecting a long day of emergency part ordering and backup restoration ahead of him.
"When entering dates through SSIS, using the numpad - does nothing! only the standard - key is recognized!
Relief quickly turned into confusion, as Tonuguelli read and re-read the email. Not only was this a problem with external software, but the expected priority was laughable. An issue with a simple workaround, which the reporting user was already aware of? This was just poking the polar bear. Tonuguelli had had enough! He looked at the email's signoff, "Argh! It's Wurnstrum Holstein again!" he exclaimed to no one in particular. Wurnstrum had been a thorn in his side for quite a while, a traditional management type with enough air between his ears that if you stood close enough when you spoke to him, you could hear the echo come back through his ear. This was the last straw.
our people can't work with this! this is a CRITICAL issue! FIX IT ASAP!"
Tonuguelli fired off an email to management explaining the situation, giving the background of frivolous IT requests and problems he had had so far with Wurnstrum. He replied to Wurnstrum's email explaining that he couldn't fix an issue with external software, and suggested that he use the workaround he had found until the issue was resolved. He knew this wouldn't be good enough, but he didn't want to deal with that right now. In all the anger and frustration, he found he had finished his coffee, so he went to get a refill.
He was startled by the sound of the front door of the building being kicked down, with men shouting and heavy booted feet running through the offices, he turned towards the commotion to see 3 men with balaclavas and assault weapons, all pointed at him "DONT MOVE" they shouted, he dropped his coffee and raised his hands. Tonuguelli, his mind full of fear, felt certain he was about to die.
He had no idea how wrong he was...
-
-
@mikeTheLiar said:
@Algorythmics said:
Wurnstrum
Wernstrom!
<br>
the guy is dutch, they cant even spell their own names on the plains.
-
-
@steenbergh said:
SSIS
Goddamned cardboard software.
Sort of related...In SqlDeveloper, when I use middle click to paste my primary selection into the parameter dialog, it doesn't realize that something has been pasted there and leaves the box checked to indicate that it should use null for that parameter.
-
@steenbergh said:
SSIS […] Debate.
SpectateSwamp Integration Services?
-
-
@dhromed said:
@dkf said:
@steenbergh said:
SSIS […] Debate.
SpectateSwamp Integration Services?SSaaS
best of bread sssaas
-
Now I am hungry.
-
IIRC, SSIS uses the Visual Studio shell. Do you have any Visual Studio plugins running? I know some remap the functionality of the number pad keys, CodeRush for example remaps Numpad - to "Selection Reduce".
-
@steenbergh said:
SSIS discriminates between numpad and regular hyphen when entering annotations. Debate.
Mdterm distinguished between the main keyboard and numeric keypad decimal points, I believe, when setting certain terminal parameters. And then there's the trouble we often had getting certain people to understand that Return and Enter were two different things.
-
@Algorythmics said:
Frontpagified that for you
Nah, the story still makes sense and conveys the same information as the original. Two / five.
-
@dkf said:
@steenbergh said:
SSIS […] Debate.
SpectateSwamp Integration Services?That'SSIS a nice database you have there. It would be a shame if something were to happen to it.