what does the SQL Logs say about licensing and allocated cores? Could be limited by license applied.

and what is the VM type - some config there may be wrong -...

you can't do that as far as I know - if you do that deny then db_owner is required - but having the list of db's on SSMS does NOT...

if you read my post and the link I gave you it states what you have to do to address that requirement.

if it is partitioned what matters is if it is has the partition operator on the plan or not - if it has then being partitioned is helping the query...

bump.. page bug

best advise is DON'T use SSIS for this.

Load data from one of the db's into a staging (or even tempdb) and do the merge on the SQL server side.

if you...

why bother sometimes. basic sql stuff that should not need our help.

straight replace -

SET @FILEPATH = replace(@FILENAME, 'chartobereplaced_escapedifneeded', 'replacewith_escapedifneeded')

you can just try out until you get the replace correct -...

If you look at the column headers of the file and compare them to the table, they don't match.  We can't see your package to know what the mapping...

this also looks like a possible execution of DTEXEC from the command line (instead of SSIS catalog/SSIS Execute step from sql agent) - and in this case its likely it...

did you use "insert into tbl with (tablock)" or without it - and what indexes do you have on destination table.

other than that I can't help as I don't have...

I'm my experience performance and validation was always better and more reliable when we converted dates (and numbers as well) to a string format (dates to YYYY-MM-DD HH:MM:SS.FFF and numbers...

• This reply was modified 1 month ago by  frederico_fonseca.

the extension does NOT matter for SSIS - you give the filename whatever name+extension you wish.

as long as the format of the rows is what you defined everything will work...

can you give as the ACTUAL explain plan of one of those slow executions - use https://www.brentozar.com/pastetheplan/ to upload the plan and give us the resulting link.

that would...

if your C# code above is on your "Data source" on the dataflow Image that is your issue - a Datasource HAS to output a datarow - not write to...

google is your friend - you should have done it first.

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16

regarding the code and because you got a timeout  I would add a command timeout before the executenonquery.