Exactly. Even though the resultsets might be slightly different, the statements are equivalent. Boooo, I want my...

Thanks again Gsquared...

Your answer makes sense but has me slightly concerned..

What I'm trying to do is basically when a dataset is imported into a "staging" table, then normalise it by...

ok, solved it myself

INSERT INTO tblType

SELECT DISTINCT [Type] from #tblUploadA

WHERE [Type] not in

(SELECT Description

...

Lars - I know where you're coming from, it could be a little better explained in parts for an SSIS newbie. If you open the solution explorer you'll see Datasources,...

OK, this was what I was trying to do (don't laugh!) 😀

UPDATE #tblUpload1

Set Section = (SELECT tblSection.ID

FROM #tblUpload1

inner join tblSection

ON #tblUpload1.Section=tblSection.Description)

It's trying to update on the results of the...

Perfect, thanks GSquared. That's actually what I'd started doing - only issue I'm having is trying to update back into the staging table - so was going to create second...