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

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

jisaac — Thu, 03 Oct 2024 17:16:01 GMT

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 this error:

Failure happened on 'Source' side.

ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: ''FORMAT' is not a recognized built-in function name.',Source=,''Type=System.Data.SqlClient.SqlException,Message='FORMAT' is not a recognized built-in function name.,Source=.Net SqlClient Data Provider,SqlErrorNumber=195,Class=15,ErrorCode=-2146232060,State=10,Errors=[{Class=15,Number=195,State=10,Message='FORMAT' is not a recognized built-in function name.,},],'

According to this article, the 'FORMAT' function was introduced in SQL Server 2012. My server is running a version prior to that. Is there anyway to work around this to allow the Copy Job to work?

Thanks,

Jacob

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

Anonymous — Fri, 04 Oct 2024 07:30:37 GMT

Hi jisaac ,

Copy Job is a preview feature of Data Factory, in order to get a better solution to your problem, I suggest you can go to the official forum of Data Factory to ask a question, there will be a professional for you to solve the problem.

Get Help with Data Factory - Microsoft Fabric Community

Here is an official document on how to use Copy Job, it may help you:

How to create a Copy job (preview) in Data Factory - Microsoft Fabric | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

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

Anonymous — Wed, 16 Oct 2024 07:16:52 GMT

Hi jisaac ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

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

jisaac — Wed, 16 Oct 2024 13:08:06 GMT

I have moved the post here: https://community.fabric.microsoft.com/t5/Data-Pipeline/Copy-Job-On-Prem-SQL-Server-Error-FORMAT-is-not-a-recognized/m-p/4218237