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. (28 Jul 2016) Why Uber Engineering Switched from Postgres to MySQL
  2. (15 Jun 2016) Why you can't be a good .NET developer
  3. (12 Nov 2013) Why You Should Never Use MongoDB
  4. (21 Aug 2013) How memory mapped files, filesystems and cloud storage works
  5. (15 Apr 2012) Kiip’s MongoDB’s experience
  6. (18 Oct 2010) Diverse.NET
  7. (10 Apr 2010) NoSQL, meh
  8. (30 Sep 2009) Are you smart enough to do without TDD
  9. (17 Aug 2008) MVC Storefront Part 19
  10. (24 Mar 2008) How to create fully encapsulated Domain Models
  11. (21 Feb 2008) Versioning Issues With Abstract Base Classes and Interfaces
  12. (18 Aug 2007) Saving to Blob
  13. (27 Jul 2007) SSIS - 15 Faults Rebuttal
  14. (29 May 2007) The OR/M Smackdown
  15. (06 Mar 2007) IoC and Average Programmers
  16. (19 Sep 2005) DLinq Mapping