Forum Discussion
Copy activity error when Destination is on prem SQL Server
Hi schneiw, as mabdollahi mentioned, the connection for Lakehouse in Fabric had multiple changes over the last few months. If your implementation was working a few months ago it could be outdated now. Rather then use a previously created connection, you need to reconfigure your Source in the Copy activity. In the new style you actually don't need to create a connection to the Lakehouse for the copy activity data source if you have access to the Lakehouse. You can just select a Lakehouse directly from the list of data sources in Fabric without having an connection object. First click Browse All
and then View More
On the next screen you'll the list of all your available data sources that you can just select as a data source in the Copy activity.
Keep in mind, with this configuration the data pipeline will try to use your connection to the Lakehouse when executing. It amy not work in all scenarios. If you are building an automated pipeline then you do need to create a Lakehouse connection and use that instead preferrably using a different organizational account.If you find this answer useful or solving your problem please consider giving kudos and/or marking as a solution.
Hi schneiw
This usually happens when the pipeline is still using an old connection type.
LakehouseSql was used earlier for the Lakehouse SQL endpoint, but Fabric doesn’t support that linked service type anymore. So when the pipeline runs, Fabric can’t recognize it and throws that error.
What to do:
Remove the existing Lakehouse connection in your Copy activity
Create a new source connection and choose Lakehouse (not LakehouseSql)
Leave SQL Server as the destination (using the gateway if it’s on-prem)
Your data and SQL are fine — it’s just an outdated connection definition.
Regards,
Mehrdad Abdollahi
Thaks for that. However, the Connection is already a "Lakehouse":
I see. and I do have the same connection that works for me as I created it few min ago.
Have you tried creating a new connection? Sometimes, the recreation works due to some unseen issues behind the scene.