I hope that server is fully licensed for SQL Server - whatever version you have installed.

running filesystem packages with dtexec directly MAY require the packages to be fully "upgraded" to...

it does keep version information.

code below from documentation - https://learn.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver16

other ways of doing it - including ci/cd pipeline - the one below just requires a share accessible by the server...

main thing is not to use native SSMS to deploy - either use VS deploy or T-SQL

apologies - missed that reply.

this is around the issue I thought - and not much you can do about it other than...

use PlanExplorer to scramble the names - https://www.solarwinds.com/free-tools/plan-explorer

that will replace any object name (db, table, column) with object1, object2 and so on - but it will leave intact the...

please post actual explain plan of the problematic query as well as the full sql statement (and of any views/functions used by it)  so we can help.

use https://www.brentozar.com/pastetheplan/ to upload...

then you have a problem as this is never going to be a slow operation - a amount of downtime will always be required, how much is going to depend...

likely the standard method of inserting into a new table with the column being calculated at that stage, and then one of 2 options

1 - truncate source table...

if the IP returned in both local PC and problem SSIS server are the same then the server is able to get the DNS entry for the target - on...

this likely a DNS issue - within the server where SSIS is running open a command line (RDP) or a xp_cmdshell, or even a custom SSIS package just for the...

all those are not available to use within functions of views - so only within batch SQL or within a SP - and with regards to 3 - yes the...

Attached is the SQL query plan.

There are two main queries.  The first uses a date parameter and the second doesn't.  The second query is much higher cost that the...

use PlanExplorer to scramble the names - https://www.solarwinds.com/free-tools/plan-explorer

that will replace any object name (db, table, column) with object1, object2 and so on - but it will leave intact the remaining...

can you give us the actual explain plan with both the 3 conditions and just 1 condition - as well as the definition of the view.

likely this is joining multiple...

This is the query with the plan (names have been changed):

DECLARE @DateColumn  DATE = '2024-07-01';

DELETE s 
FROM [Schema].TableName s 
INNER JOIN #WorkingTable q
ON q.Column1...