Stand down!!!. All sorted now.
My error was to try and add the SQL as an expression here

instead of simply writing it here

Hi Phil, I am so sure this is easier than I am making it.
You are right, the derived column didn't work as required.

So I have now...

Hi Phil, renaming parameters hasn't helped.
I am going to approach this using a "derived column" method as I think it will make life easier.
I will let you know...

Hi Phil,
Thanks for taking the time to reply.
I have gone with option 1.
I have added all 5 parameters to the parameter mapping page like so

By the way, a 100% error is all rows diverting to error output! 🙂

Hi folks cheers for taking the time to help. It was hitting some constraints on the destination table. The error text was simply 0 which is mega helpful obviously. Had...

Hi Phil, thanks for the reply. Derived_Status is already a mapping table field that I am joining to in the SQL, the case when is simply:

Case when Derived status...

Hi cwe242 thanks for the suggestion. I shall try it tonight and let you know how it works. Regards

Dave

Hi, I have come up with a different solution, not quite as sustainable with high data voulmes but as the volume will be relatively low for this process, I have...

Hi, I ordered the ETL book  (2nd in the set) the other day. I am excited to read it.

Dave

Hi, I am sorry I haven't seen the older version so I cant say what the differences are.
The books are great so long as you have a good knowledge...

As others have said, start here: