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...

What does 'blank' mean? Empty string? What about columns that are not strings? What do you mean by 'all fields are dynamic'? Tables have columns, not fields.

This is what you should solve first, in my opinion. It's not a...

This is not particularly elegant, but it seems to get the job done.

Next time, please remember to post your sample data in consumable format, so that others can simply paste...

As I suggested in one of your other threads, SSIS needs to 'see' the table it is going to load data into at design time, not at run time.

Do the...