Forum Discussion

jisaac's avatar
jisaac
Icon for Helper II rankHelper II
1 year ago

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...
Need Help
jisaac's avatar
jisaac
Icon for Helper II rankHelper II
1 year ago

Still 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's avatar
FabianSchut
Icon for Solution Sage rankSolution Sage
1 year ago

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

  • jisaac's avatar
    jisaac
    Icon for Helper II rankHelper II
    1 year ago

    Hi FabianSchut,

    Copy activity from pipelines work on my SQL Server 2008 R2 database, yes. I have been using them for several months. I was interested in the automatic Incremental Loading feature of the Copy Job, so I'm hoping to switch if I can get it to work.

    (I already have an incremental loading system working with Notebooks, but it's rather clunky.)