Between that and the GENERATE_SERIES()  defeating Minimal Logging (article coming out on that on the 18th) and the DATETIME rounding issues into the next day that started in...

You'd think someone working in it would know how to ask for help properly..... developer just sent me.

"the UAT ETL server seems to be really slow this morning.  Any reason...

I think that is a good point.  Review what the developer has actually submitted, not other stuff.  Obviously there are some "It depends" scenarios.  Restricting the blast radius is...

Large PR's are the result of a bigger problem, code bloat caused by not properly compartmentalizing components.

LOL this has to be an add bot.  Informatica hasn't had a major update in something like over a decade and doesn't support(or barely) many...

Then just take out your logic that's creating the destination directory?

If it doesn't exist the copy-item will error out.

The example I gave was just add the MMYYYY to a file, it looks like you already have the logic to create the destination directory if it doesn't exist.

So now...

I tend to subscribe to the idea of it's better to have the data and not need it than need the data and not have it.  There's obviously some limits...

If the port number is...

Yes you would still need to have your directory create logic in there, that was just to handle adding the date stamp.

Well your file copy could look something like,

$file | Copy-Item -Destination ($destination + ($file.BaseName + "_" + (Get-Date -Format "MMyyyy") + $file.Extension ))

Unfortunately that is a super generic java error from the sql driver, we've had a lot of issues with that and it's hard to point to a root cause.  An...

I think there shouldn't be time zones, let alone DST. The entire globe should be Noon, as an example.  Pick a time zone, and the whole world can follow...

What about the hybrid approach where HIPPO demands data be manipulated to match?

Just be careful if there's more than 1 completed subtask for the same task 🙂