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

Thanks for your response, but this is not helpful. I am not the one making the FORMAT call, it is the Copy Job doing it natively. I'm asking if I can change Copy Job to not use that function call, or if there is another work around.

Also, I already linked a similar post in the original post.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

I don't think Microsoft will want to support that legacy setup.

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

    Then is there a workaround I could do on my end?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      you mean, apart from upgrading your database?

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

        Yes, of course. The program using the SQL server is being replaced, so there's no benefit in upgrading the SQL server version. I also don't know if the program would support the newer version of SQL server. After a year or two, data will stop changing on the program as we'd be completely moved over to the new program. Until then, I need to pull data incrementally from both systems.