There is an FTP task in SSIS (https://learn.microsoft.com/en-us/sql/integration-services/control-flow/ftp-task?view=sql-server-ver17) and it works. Not SFTP though.

Works fine and I ahve friend still running xfers via ftp (or sftp via third party)

Glad you liked it

Yes, indexing makes a huge difference and the performance savings can overwhelm the index creation time/CPU

I find that the more talented people are with a skill, the less they trust an AI or want to use it. It's interesting, because it "reasons" about as well...

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver17

I lean towards Uwe's solution, especially when I need the table to stay online and accept insert/update/delete while I'm deleting data.

Microsoft implemented a change requiring a cert that is trusted through the local hierarchy, or the client clicking "trust cert". Depending on which client versions were upgraded or servers changed,...

If this (MaxCatalogConnectionPoolSizePerProcess) is set to 0, then the client value is used. You might set this higher. Similar question (or yours)

https://learn.microsoft.com/en-us/answers/questions/5646615/catalog-max-connection-pool-size-100

I think you need more connections set up...

Thanks, and I get it. The team is trying to figure things out. If you can repro, that would be great.

Lol,

Phil, how did you get that URL? Was it something from your profile or somewhere on the site? Those are old style URls, that we've blocked.

Lol, I used to pile up requests on my desk as I got busy. Just tell people to drop them there, along with email requests I'd print out.

at some point,...

Lol, I used to pile up requests on my desk as I got busy. Just tell people to drop them there, along with email requests I'd print out.

at some point,...

I think I need a beer. Got double posted somehow.

Mot sure either. We've been having some DDOS attacks. 900 req/s to the load balancers at one point, overwhelming things.

they did some work on nginx to block some URLs, mostly...

Mot sure either. We've been having some DDOS attacks. 900 req/s to the load balancers at one point, overwhelming things.

they did some work on nginx to block some URLs, mostly...