sample DTSX package attached.

you will also need to install Oracle Client for Microsoft tools -...

• This reply was modified 1 years, 9 months ago by frederico_fonseca.

even with SSIS...

you can start by reading the manual - https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-date?view=powershell-7.4

and as alternative, you pass your desired date in date format to your sql, and within the sql itself you convert to...

I'll see if I can find one - I know I have some outside SSIS,...

there are commercial tools for it , and this one from MS https://www.microsoft.com/en-us/download/details.aspx?id=103016 - never used it though

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 called as

Get-InstalledDatabaseDriverList...

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 1 years, 9 months 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.