Share via

Error Power Query Source in SSIS

Tommy Trung Ngo Quang 1 Reputation point
2021-01-29T07:25:01.053+00:00

I have a error when using a Power Query in SSIS, the details of the error is as following. IF anyone has a solution for this, please help

[Power Query Source [2]] Error: System.Runtime.InteropServices.COMException (0xC0047072): Exception from HRESULT: 0xC0047072
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSExternalMetadataColumnCollection100.FindObjectByID(Int32 lID)
at Microsoft.SqlServer.IntegrationServices.PowerQuery.Framework.ExternalMetadataComponent.GetExternalColumnMapping(IDTSExternalMetadataColumnCollection100 externalColumns, Int32 externalColumnLineageId, Int32 hBufferType, Int32 lineageId, DataType dataType, String columnName)
at Microsoft.SqlServer.IntegrationServices.PowerQuery.Framework.ExternalMetadataComponent.GetExtendedBufferMappings(IDTSOutput100 output)
at Microsoft.SqlServer.IntegrationServices.PowerQuery.PowerQuerySource.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,455 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-01-29T08:01:46.66+00:00

    Hi @Tommy Trung Ngo Quang ,

    1.Please check if you can test PowerQuery Connection Manager successfully.

    2.Please check if you can Detect Data Source successfully in Power Query Source Editor.

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.