More annoying stuff about SSIS
time to read 1 min | 146 words
- You can't close a package after execution. You've to manually stop debugging and then close the package.
- No way that I could find to look at just the errors/ warnings from the log.
- The Flat File Source just blithedly ignored the fact that the file doesn't exists and carried on its work. I need this behaviour in several places, so it would be useful to do it, but I've no idea why or how this works.
- You can't edit connection managers without a live connection to use.
- You don't get any results when you search for the errors on Google.
I'm not sure how I got the situation below, but I did get it. I'm pretty sure that this shouldn't happen. It got so many stuff wrong that I don't know where to begin checking. More so, I don't know how to check this stuff.
Comments
Comment preview