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!

    our people can't work with this! this is a CRITICAL issue! FIX IT ASAP!"
    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.

    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...


  • @Algorythmics said:

    Wurnstrum

    Wernstrom!

               <br/>
    WERNSTROM!



  • @mikeTheLiar said:

    @Algorythmics said:
    Wurnstrum

    Wernstrom!

               <br>
    WERNSTROM!

    the guy is dutch, they cant even spell their own names on the plains.



  • @Algorythmics said:

    amazing comment

    Where is the like button?


  • ♿ (Parody)

    @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.


  • Discourse touched me in a no-no place

    @steenbergh said:

    SSIS […] Debate.
    SpectateSwamp Integration Services?



  • @dkf said:

    @steenbergh said:
    SSIS […] Debate.
    SpectateSwamp Integration Services?
     

    SSaaS



  • @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.


  • Discourse touched me in a no-no place

    @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.


Log in to reply