Post reply

SSIS 2008 - Need help with expression in derived column.

  • October 24, 2014 at 7:08 am

    #1754638

    cafescott (10/24/2014)

    I've said this before, so hopefully I don't come off as a broken record. However, I would never use derived columns in SSIS. Instead, I would use SQL. One advantage of this approach is I can see the data as I test. The other advantage is I am keeping my business logic in the same place as whatever is the source of the rest of the query.

    Another advantage is that you don't have to use the awful one-line derived column editor 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 24, 2014 at 7:13 am

    #1754641

    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!

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply