Try using the full UNC path, eg:

\\servername\c$\folder\filename

(after verifying that the user running the job can access that path)

Also check that your proxy is being picked up properly by checking the...

Well done.

Now, how about fixing whatever it is that puts that garbage into your Audit Trail table in the first place? 🙂

You're right, it's probably not the same issue. But it was the only thing I could think of which was at all similar.

Lastly is getting SQL Server using the same...

Does [ProvidersDirectory].[dbo].[ProvidersTable] have the source data column?

If so, use that.

If not, where does the source data come from?

I have seen a problem in the past which may be related. In my case, the version of .NET being used by SSDT appeared to be a later version than...

Your variable @source is not being set, hence the NULLs.

Package properties don't affect the bitness when set up as an Agent job.

Instead, to run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use...

I assume you are familiar with the REPLACE function, with which one can easily change the _X0020_ back to a space?

If you are asking about how to avoid the issue...

Do you believe this to be a detailed and thorough response to...

The biggest benefit I can think of is that this method provides total control over how changes get deployed, rather than relying on SSDT's schema-differencing and updating tech, which is...

Can you explain the logic behind this requirement, please?

I cannot see any questions in your post. What, specifically, do you need help with?

Can you provide some sample code which we can cut & paste into SSMS?

Microsoft Excel,...