I have previously posted a question yesterday and thank you all for your quick response.

I’ve nearly completed the SSIS package but unfortunately it stalls(doesn't error and have left it for 15 - 20 minutes) at the last step.

The step that it stalls on is the updating of the lookup values from the lookup. I’ve tried many ways on performing the lookup cache and a query

I currently have a SSIS with the following

OLE DB Source

Data Conversion - (To change my lookup value from int to nvarchar to match it in the lookup)

Derived Column - (ltrim(rtrim(column)

Lookup

OLE DB Destination

Any ideas ?