regardless - check every server that is part of that AG and ensure that only the 64 bit version of the driver is installed.

use script from https://www.powershellgallery.com/packages/LegacyData/3.2.0/Content/Public%5CGet-InstalledDatabaseDriverList.ps1

can be...

this looks like a failover issue where the servers installed version isn't the same - one has a 32 bit version and the other a 64bit version.

I would check this.

Hi All,

How important is it archiving old data ? In recent days, We saw some timeouts and blockings happening for app API calls to the database.  Later, found that...

Appreciate the replies!

The script I used most recently is this:

declare @period varchar(10) = '2024MAR'
 
declare @innerCommand varchar(500) = 'select * from FACT_GL_ACTUALS where TRX_PERIOD = ''''' +...

Thanks all...

I tried using a dynamically generated openquery statement and, while it's not as fast as I was hoping, it's definitely a lot faster than before.  Going to try...

based on what you said I STRONGLY recommend that you change the process to use either a ETL tool (SSIS or plain C#- SSIS will likely be the slowest -...

you saying that "select * from remoteoracle where a = b" is slow?

or is it when you are joining to local tables (big NO NO).

but regardless - access to remote...

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

BSEG is a heap - why don't you have a Clustered index on it?

and reason for not using any of the other indexes may also be related to not having...

I would consider this a duplicate post - and as mentioned on the other ones you are the one that needs to figure out what your SSIs package does and...

you said "  DB is set to read committed" - does this mean your db has Read Committed Snapshot Isolation on? if so this is likely why.

you have already been given some answers on your original post - https://www.sqlservercentral.com/forums/topic/eliminating-csv-conversion-step

with regards to the errors, they are standard SSIS errors, which you can both read manuals...

so you are asking us to do your work for free?

one thing is to help with particular issues or problems. Error you may get with code for example.

But this is...

easy - would help if you had created a script task (as instructed on the link) instead of a script component.

so do it correctly - script component does NOT allow...

in addition to what Phil supplied - which may mislead you into thinking you can set it up to bypass this particular issue.

SSIS catalog  DOES NOT allow for double hop...

and as I said on my prior post - it will not work like that as it is a double hop situation - only way for this execution to work...