Forum Discussion

PaulineSP's avatar
PaulineSP
Frequent Visitor
7 months ago
Solved

Copy Job to copy On Premise SQL Server tables to Fabric SQL is failing

I get this error after setting up a copy job  to copy On Premise SQL Server tables to Fabric SQL Database I have successfully seen this done on You Tube https://www.youtube.com/watch?v=Ae77yoGqqnM&t...
SQL database
  • tayloramy's avatar
    tayloramy
    7 months ago

    Hi PaulineSP, 

     

    Can you provide us some more details about the configuration? 
    Can you add screenshots of the set up? 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

PaulineSP's avatar
PaulineSP
Frequent Visitor
7 months ago

The details are very simple - I am connecting to an On Premise SQL Server via an On Premise Gateway. The copy job allows me to connect to the on premise server, select the database and table I wish to copy, preview the contents of the table, view the column mappings, start the copy job but after about 1 minute the copy job timesout with the above error. I have tried both a Pipeline with copy job and a Dataflow Gen 2 but am unable to successfully copy data. I have now reported this to Microsoft and they are doing an investigation. I will update this forum when I get an answer from Microsoft

 

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
7 months ago

Hi PaulineSP ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

 

Thank you