VS 2022 SSIS Lookup with NoCache Error

Question

Jayalakshmi, Roopa (Consultant) 0

I am facing issue with upgraded package from 2016 to 2022 where the Lookups with "No Cache" mode is throwing error in runtime. Capture

Jayalakshmi, Roopa (Consultant) 0 Reputation points

2023-06-01T13:35:56.05+00:00

I have checked all the possible ways to clear this error but its not showing for all lookups but randomly showing up for each table. Because of this we are not able to complete our Upgrade process. Thanks

1 answer

Jayalakshmi, Roopa (Consultant) 0 Reputation points

2023-06-01T13:35:56.05+00:00

I have checked all the possible ways to clear this error but its not showing for all lookups but randomly showing up for each table. Because of this we are not able to complete our Upgrade process. Thanks

Answer 1

ZoeHui-MSFT 41,481

Temporarily SSIS2022 does not have a GA version, it is highly suggested to use SSIS2019.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.