Looks to me like it should run just fine and I agree with your assessment of what the error indicates.

I suggest that you open up the package in Notepad++ and...

I am going to test this now.  When this was originally set up I believe encrypting the data was believed to be the best practice. But all of our...

Sample data should be provided in a form which can be executed in SSMS, as you should well know.

DROP TABLE IF EXISTS #Policy;

CREATE TABLE #Policy
(
  ...

Not directly possible, as far as I know.

But there may be an alternative approach. It is possible to execute multiple instances of the same package, in parallel. With some careful...

What are your reasons for not using Don't Save Sensitive & supplying sensitive data via parameters and SSISDB environments?

My understanding agrees with yours: you need a WSDL to use the Web Service Task.

Using a Script Component Source (which I assume is what you meant?) is not what I...

I would not use a lookup here - I would load the full file into a staging table.  From there you can perform a merge or upsert (update/insert) from...

I have table1

Col1   Col2   update_date

ABC   ab        04/04/2020

ABC   ab        05/04/2020

ABC   ab        08/04/2020

BCD   bc        09/04/2020

CDE   cd       ...

We cannot easily help with this, based on what you have posted.

Are you using a unique identifier in the lookup? Is it unique in both the source file and the...

This might help:

SELECT calc.dt
      ,TotAmt = SUM(   (CASE
            ...

Why have you started a new thread about this?

Original thread here includes as-yet unanswered questions for the OP.

This does answer a question, but not the one posed by the OP!

Although we are running the ssis in every 3 minutes.

Are you saying that this is what you do currently and you want to change it? If so, as 'Daily' is...

Please tell us what this function does, in words.

Your request seems to be the equivalent of "I would like a way of importing delimited text files. For each file, I do not know what the delimiter is, nor...