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

Here are the results of the queries you provided. Now tell us what the logic is to get from here to the results you require, as it is not clear...

Use an...

Assuming your target column's datatype is 'DATE', it does not have a display format.

If your import is converting formats from DDMM to MMDD, you would get lots of errors for...

There is something strange going on here.

Are you trying to create a table within a data flow? (I see a Mappings node)