Copy Job (Preview) On-Prem SQL Server Error: 'FORMAT' is not a recognized built-in function name.

Hello,   I was trying out the Copy Job (Preview) item as what it is meant to be will be very useful for me. I attempted to pull data from a SQL Server running an older version. I was greeted with t...