cafescott (10/24/2014)
Well, if you keep all your querying logic in one place rather than splitting some of it off in SSIS, it makes it easier to find it later on. Then again, using derived columns does introduce some measure of job security, so maybe it isn't that bad of an approach. 😛
SShhhhh!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.