I had someone say to check the advanced tab in SSIS

https://x.com/fv439/status/2001016477722562647?s=20

Backing up will almost certainly preserve corruption, but ensuring you have a backup is critical. l'd certainly make an extra one before I start doing anything. Never know when someone...

I'd echo what Brian wrote. Work with VEEM on this

Anytime someone makes a "never do this", I'm skeptical. First, never is a long time, second, they often don't really have a rational reason.

AI isn't magical now, and it can...

The error looks like a firewall thing to me. Can't establish a connection.

I might connect to the source SQL Server and verify the source db is accessible. Meaning that TDE...

Not entirely sure, but I do know there is a proc that you can run, which might do what the auto cleanup is missing: sp_flush_CT_internal_table_on_demand

I might run that and...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense...

I am currently in the midst of a refactoring project primarilly intended to "quiet" the log files.  Non-catestrophic errors and warnings are polluting the log files causing unacceptable growth.

One...

I tend to adopt Aaron's view a lot. I am refactoring my code and trying to make it better, but also help me clean things up that are an investment...

You can ask the AI what they did. I asked to restore a single table. Got "RESTORE FROM DISK WITH SINGLE_TABLE". Told it didn't exist but I could have pasted...

This apply?

https://support.microsoft.com/hu-hu/topic/kb4538365-fix-change-tracking-cleanup-does-not-work-when-invalid-cleanup-and-hardened-cleanup-version-are-negative-in-sql-server-2017-and-2019-f186bd92-622c-89f2-a6c2-739c250593f2

Expired records should be those that are in the tables, but should be deleted. Are you saying based on settings there aren't any records in the on-disk table...

Jason,

ask yourself this. Is the vibe coding any different from blindly approving a PR from a colleague? Or having to support someone else's code who you know takes shortcuts?

Those lawyers...

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