You are displaying the properties for a data flow task.

Instead, click on a blank area on the Control Flow window and you should get the properties for the package.

You want your proc to have two options? Like 'Incremental' and 'Full', is that right?

Full is easy, just add:

TRUNCATE TABLE ...

INSERT TABLE ... results of proc

to your proc.

Incremental is harder,...

Sorry, but I really have no idea. Never seen anything like that.

But if you are opening the .sln, you should not be having a problem with the project-level connections, so...

What problem does this cause? Can't you just set the protection level manually?

Was the package developed in 2019, or could there be versioning issues?

If the original developer used project-level connections,...

but why the addition of "@myFlag <> 1)" make it work ?

It's straight logic.

You had two scenarios:

1. SELECT all rows if myFlag not 1
2. SELECT some rows if myFlag =...

DROP TABLE IF EXISTS #Test;

CREATE TABLE #Test
(
    id INT
   ,name VARCHAR(10)
);

INSERT #Test
(
    id
   ,name
)
VALUES
(1, 'A')
,(2, 'B')
,(3, 'C');

DECLARE...

It sounds like you know what you're doing, so I suspect you'll have considered this already, but could it be down to parameter sniffing?

Hi,

I have a job running SSIS package, which has 2 sql server connection managers using sql logins, one connection manager to a local log...

event viewer - see this link for some info https://docs.microsoft.com/en-us/sql/integration-services/performance/events-logged-by-an-integration-services-package?view=sql-server-ver15

better to run packages on filesystem or catalog - easier to check errors and easier to change...

If you check the All Executions SSISDB report, does that provide any additional information?

Are you sure that these are deadlocks, and not just locks? As you are inserting, I would not expect deadlocks & suggest that more investigation is needed.

Hi,

I have a job running SSIS package, which has 2 sql server connection managers using sql logins, one connection manager to a local log file, one to a...

I...

What is the source data for this? Where do these variables come from? What will the 'dynamic string' be used for, once it has been created?

That does not look feasible to me.

It would be helpful if you could explain the background and reasons for trying to do this – there may be some other way...