not those settings (which should be changed in most occasions - just don't set it to automatic on newer version of SSIS)

look at https://learn.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-destination?view=sql-server-ver16

setting can be applied on the execution of the script itself - changing global policy is bad - but changing to execute a internal script with the setting on is...

please do not create duplicate posts - you have already posted this (see https://www.sqlservercentral.com/forums/topic/updated-table-not-displaying-data) and you have gotten several replies - fact that they are not what you...

get them properly formatted.

what you gave us is on a single straight line - so its unusable.

but I do have to say that if this is not giving you what...

likely you doing it incorrectly.

following works fine with SSMS 19.0.

2

where contents of the script is just a straight "gci c:\"

for true prod code I tend to avoid merge - performance vs insert/update can vary - either faster or slower and no quick rule to decide on it - its...

As the table is partitioned by a date - are records on "older" partitions ever updated/inserted/deleted? if not any index operation should be done on recent partitions only, which would...

look at this thread as it gives a good explanation - better to turn that setting off - https://stackoverflow.com/questions/59505490/ssis-2019-autoadjustbuffersize-causes-buffer-allocation-error

you did NOT give us the SQL code you are running - so nothing for us to advise on - just giving a table content and stating  you get no...

That script snippet seems to update the wrong job. The obfuscated name is larger than "DWLoad" for the job name in the job properties screenshot. Are you sure you...

try

CREATE EVENT SESSION [Performance monitoring] ON SERVER
ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1)
ACTION(sqlserver.client_hostname,sqlserver.database_name,sqlserver.nt_username,sqlserver.plan_handle)
WHERE ([package0].[greater_than_int64]([duration],(30000)) AND [sqlserver].[username]<>N'NT SERVICE\SQLTELEMETRY'))
ADD TARGET package0.event_file(SET FILENAME=N'...',max_file_size=(5))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO

• This reply was modified 4 months, 2 weeks ago by  frederico_fonseca.

or use MSDN licensing - but this has a whole bunch of other implications for everyone that accesses the server with it.

its a bug - will be fixed on future CU - helps reading the documentation https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate27

and is the insert a single statement inserting single row values or is it the result of joining other tables - including the possibility of being done on a merge...

edit: dup post

• This reply was modified 5 months ago by  frederico_fonseca.