ReSSIS - 15 Faults Rebuttal

time to read 3 min | 476 words

Seems like this is the new trend right now :-) Phil Brammer has posted a rebuttal to my original post. Here are my answers:

Bad Errors:
You have to understand though, that this isn’t .Net.  SSIS has many components/engines at work that obtaining the correct error isn’t always at the heart of the SSIS engine.  It could be a database error.  It could be an ADO error.  Whatever it may be, I agree, some are cryptic, but I’ve generally been able to diagnose my errors.  And if there is an error I don’t know about, I contact the community and finally Microsoft through product support.

Error handling is a key part of any platform, this should be a first level concern, that it "isn't always at the heart of the SSIS engine" is a serious issue. Errors happens, and I need to know the entire chain of issues in order to figure how to fix it. To clarify how important that is to me, I am using .Net because it has exceptions, rather than HRESULT.

Random Errors:
The fact these are random should banish this item from your “SSIS 15 Faults” list.

The product sometimes gives an error, for no deterministic reason, and you consider this a non issue?

Keeping track of what it shouldn’t:
Never had this happen.  NEVER.  NEVER, NEVER, NEVER, NEVER.  Did I make my point? 

Yeah, your point is "It works on my machine".

Sorry excuse for deployment:
I don’t understand any of the points made here.  Deploying to a server has never been a problem.  It is in the manual that metadata cannot change between databases/tables.  So if you’re moving to an environment that has its metadata different than another, you need to reconcile that first. 

I had the package fail with validation errors when moving to production when the DB schema was identical, invalid meta data errors. I don't want to reconcile anything, the schema is identical for the tables that I am working on. And let me point out that "it is in the manual" carry little weight with me, I am disliking the need, not disputing its documentation.

UI Formatting instructions:
Ah, well, what would you say if the SSIS dev team decided to make SSIS packages binary?  THEN WHAT?  At least you have an XML file that can be parsed.

Uh, you do realize that for all intents and purposes, the file is binary, right? The fact that it happens to be XML based doesn't make it human readable, source control friendly or diffable. All of the above are critical to development.

Bad interoperability:
Is your Oracle example an SSIS problem, or the Oracle driver’s problem?????????

That is probably an SSIS error, but see my previous point about bad errors to know what I am not sure.

More posts in "Re" series:

  1. (23 Jun 2021) The performance regression odyssey
  2. (27 Oct 2020) Investigating query performance issue in RavenDB
  3. (27 Dec 2019) Writing a very fast cache service with millions of entries
  4. (26 Dec 2019) Why databases use ordered indexes but programming uses hash tables
  5. (12 Nov 2019) Document-Level Optimistic Concurrency in MongoDB
  6. (25 Oct 2019) RavenDB. Two years of pain and joy
  7. (19 Aug 2019) The Order of the JSON, AKA–irresponsible assumptions and blind spots
  8. (10 Oct 2017) Entity Framework Core performance tuning–Part III
  9. (09 Oct 2017) Different I/O Access Methods for Linux
  10. (06 Oct 2017) Entity Framework Core performance tuning–Part II
  11. (04 Oct 2017) Entity Framework Core performance tuning–part I
  12. (26 Apr 2017) Writing a Time Series Database from Scratch
  13. (28 Jul 2016) Why Uber Engineering Switched from Postgres to MySQL
  14. (15 Jun 2016) Why you can't be a good .NET developer
  15. (12 Nov 2013) Why You Should Never Use MongoDB
  16. (21 Aug 2013) How memory mapped files, filesystems and cloud storage works
  17. (15 Apr 2012) Kiip’s MongoDB’s experience
  18. (18 Oct 2010) Diverse.NET
  19. (10 Apr 2010) NoSQL, meh
  20. (30 Sep 2009) Are you smart enough to do without TDD
  21. (17 Aug 2008) MVC Storefront Part 19
  22. (24 Mar 2008) How to create fully encapsulated Domain Models
  23. (21 Feb 2008) Versioning Issues With Abstract Base Classes and Interfaces
  24. (18 Aug 2007) Saving to Blob
  25. (27 Jul 2007) SSIS - 15 Faults Rebuttal
  26. (29 May 2007) The OR/M Smackdown
  27. (06 Mar 2007) IoC and Average Programmers
  28. (19 Sep 2005) DLinq Mapping