Copy Job On-Prem SQL Server Error: 'FORMAT' is not a recognized built-in function name. [Moved Post]

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...