November 2, 2011 at 10:49 am
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
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