Trying to connect to the Fabric Lakehouse from the SSIS Package. However it is failing when executing the package

Question

I have Fabric Lakehouse as a Source , I am able to connect to the Fabric Lakehouse via Authentication as "ActiveDirectoryPassword" from SSMS without any issue.

I am creating the SSIS package and created the ADO.NET connection Manager and connected to the Fabric Lakehouse. Test the connection successfully. (No problem till here)

I define my destination as on-prem SQL Server database. (No issue either)

I am able to preview the source Fabric Lakehouse data as well as shown below :

However when I execute the package I am getting the error :

[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {F8AB7C83-2542-4401-A216-8884BCABFDE6} with the following error message: "Could not create a managed connection manager.".

[SSIS.Pipeline] Error: ADO NET Source failed validation and returned error code 0xC0208449.

[SSIS.Pipeline] Error: One or more component failed validation.

Answer 1

@Vineeta Trivedi

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

MS Fabric and SSIS is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

You can ask the experts in the dedicated MS Fabric community forum.

Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

Hope this helps. Do let us know if you have any further queries.

Thank you.