re: #274 thedopefishlives

I suppose if you’ve already done the proof of concept, it might not be that bad. I’ve long since learned that SQL Server can be a bit of a mixed bag, depending on what you’re trying to do with it.

Yes. And debugging SSIS packages can be a massive pain since the diagnostic messages are sometimes very unhelpful or actually triggered in a part of of the processing far distant from what turns out to be the actual problems. Combined with the fact that I only work on the packages now and then and am thus rusty when we need to add or modify an interface. Complicated by the fact that the Autosys scheduler that runs the packages (via .bat files) is just production and doesn’t have a QA scheduler for testing. :p