Forum Discussion

HankoSwart's avatar
HankoSwart
Frequent Visitor
1 year ago
Solved

Copy Job from SQL Server DB Error - advice needed

Hi All,

 

I have been trying to get our on-prem SQL DB data into Fabric but with no success when using the Copy Activity in a pipeline or by using a standalone Copy Job. I can select tables and columns from the SQL DB when setting up the job and also preview the data, so clearly the connection works.

 

No matter what I do, I keep getting the same error when running the job:

"Payload conversation is failed due to 'Value cannot be null.

Parameter name: source'."

I've now tried the following and am getting the same error every single time:

  1. Updated the Gateway to the latest version

  2. Recreated the connections in Fabric

  3. Tried different databases

  4. Tried different tables

There is also an Error Code with a link to Troubleshoot connectors - Microsoft Fabric | Microsoft Learn but this is unhelpful as the error code is not listed. I also cannot see where this "source" parameter is

 

Any help would be greatly appreciated

 

 

 

 

Need Help

3 Replies

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Hi HankoSwart,

     

    Just following up on my earlier suggestion to raise a support ticket regarding the issue. Could you please confirm if you’ve been able to proceed with it, or if you need any assistance with the process?

     

     

    Thank you for your understanding and participation.

     

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

    If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

    Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

     

    Thank you for your understanding and participation.