MVDBA (Mike Vessey) wrote:
hahahah - we must have been typing at the same time and hating the same thing about CSV … lol
literally 2 days ago I was asked why the "Manual Corrections CSV" Import on the old system isn't working as they expect.
It's not the first time we've told them that
a) we're replacing that old crap IBM Data Manager piece of crap with an SSIS Package on new OS & SQL Server
b) unless requested we're not touching it even with a poke stick
and saying I've been asked was a matter of my superior (not the guys using this crap) asked me because they well … fear me or something like that because I'm plain honest … I just pulled up the logs from last nights Import which was something like 8000 rows imported, 70+ rows dismissed. I've provided my superior with a screenshot from the DM Log so a "BUT it MUST be something they did …" is instantly killed off.
For the record: I never ever did anything inside that DM thing except maybe copy & paste SQL Statements from there to SSIS. And two days later after they sorted their crap the data suddenly appears in the DWH, no $#&§ sherlock …
Things like woeful user input prevents me from blogging about work because all those examples are so … perfectly working … if I'd blog about my work I'd have to start with half a page of rant about what's wrong with users and relationally acceptable data, or at least sane data before I'd get to talk about anything useful.
Tho don't worry about the RDMA post, no user Inputs involved there and the NICs are already ordered 😉