regarding adding the details to the same line I gave you the way to do it - using Expressions @{N='Name'; E=Expression} you can add anything you wish to the output.

another...

• This reply was modified 7 months, 3 weeks ago by  frederico_fonseca.

code had a "," too many.

below works

$location = "C:\TEMP\FailedSQLLoginSearch_AllSvrs.csv"
$Names = Import-Csv -Path $location

foreach($n in $Names)
{
    try {
       ...

Sigh. I wish I could take comfort in "Your emergency is not my emergency." Sadly, my job makes other people's emergencies my emergency.

Any powershell gurus around? I'm still in...

try the following.

assuming that your csv file (you have it as xlsx which I believe may be a typo) contains 3 columns - SQLServerName, IPAddress and LoginName

foreach($n...

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 8 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 8 months, 1 week ago by  frederico_fonseca.

even...

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

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