Just confirmed and my original reply was incorrect - it is one per file - but note that you can't change the file name on the fly, any change to...

are you sure you ticked the right boxes on the Oracle install? default will not install the required components.

also on a server only the 64bit version should be installed -...

it is but not advisable - a Excel linked server is 1 per file per tab - not something I would setup.

if your DBA is ok with installing the MS...

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