Forum Discussion
jisaac
Helper II
Helper IICopy 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...
jisaacHelper II
Helper IIStill looking for a solution to this. Is it possible to create my own FORMAT function on the sys schema that Copy Job will call?
FabianSchut
Solution Sage
Solution SageHi jisaac,
Could you try to use the Copy Activity within the Data Pipeline instead of the Copy Job? I'm not sure whether Copy Activity does not use FORMAT, but you could try that out.