Post reply

Excel Sheet Erro

  • November 2, 2011 at 10:49 am

    #262192

    Hi Friends.,

    select distinct R.PRE_DIR,R.ST_NAME,R.ST_TYPE,R.SUF_DIR from GcRange R

    Left Outer Join GcRange L on

    L.OBJECTID != R.OBJECTID and

    IsNull(L.PRE_DIR, '') = IsNull(R.PRE_DIR, '') and L.ST_NAME = R.ST_NAME and IsNull(L.ST_TYPE, '') = IsNull(R.ST_TYPE, '') and IsNull(L.SUF_DIR, '') = IsNull(R.SUF_DIR, '')

    and L.FROMLEFT <> 0 and L.TOLEFT <> 0 and L.FROMRIGHT <> 0 and L.TORIGHT <> 0

    where

    L.ST_NAME is null

    and R.FROMLEFT = 0 and R.TOLEFT = 0 and R.FROMRIGHT = 0 and R.TORIGHT = 0

    the above is my query...i couldn't use this in sql command of Excel source....it says something like this " wrong number of values passing the arguments isnull(L.PRE_DIR, '') "

    can any one help me pls?

    Thanks,
    Charmer

  • November 2, 2011 at 11:28 am

    #1402307

    As far as I know, "Isnull" is not a valid Excel function so it cannot be used in queries against an Excel connection.

    You would be better off extracting all the fields from the Excel file and using the "Derived Column" transformation in SSIS to check for empty values etc.

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

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