it could be other things and just seeming like that to your Oracle team. reason for me asking for the code you use was also to see if there had...

and how will that work within a Stored Proc?

could you supply the code that is doing that insert - including both the retrieval of data from SQL Server and the sending to Oracle.

And DDL for source columns being...

• This reply was modified 2 years, 5 months ago by frederico_fonseca.

and I have to query the design of that process - why do you have 2 different VM's trying to delete older rows from dbo.Logs_Epass without any other criteria than...

with few exceptions, and when number of cpu is now, maxdop should not be set to higher than half the number of cores - so one query does not hog...

not if you need to keep part of the data on the source table - a SWITCH means all table contents gets "moved" to a new table, or 1 partition...

sample DTSX package attached.

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

• This reply was modified 2 years, 5 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 = ''''' +...