SSIS Error

Question

SSIS Error

Manny 151

Hi
I am creating an SSIS package in Visual Studio 2019. I am using SQL Server 2019. I am getting below error. I have no clue what is going on. Is someone able to help me?

=====

ERROR

SSIS package "C:\Users..\Package.dtsx" starting.
Error: 0xC004801F at Data Flow Task, SSIS.Pipeline: The component metadata for "Power Query Source, clsid {7CDF593F-DE06-4ABD-B356-7976EF7AC8E0}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC001000E at Package: The connection "{93FCED95-1D22-4CE3-9F3A-55D4485937FE}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error: 0xC004800B at Data Flow Task, SSIS.Pipeline: Cannot find the connection manager with ID "{93FCED95-1D22-4CE3-9F3A-55D4485937FE}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "Power Query Source.Connections[Web Connection]" in the connection manager collection of "Power Query Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: Power Query Source failed validation and returned error code 0xC004800B.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "C:\Users...\Package.dtsx" finished: Failure.
The program '[19084] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

=========

SYSTEM INFO

Microsoft Visual Studio Community 2019
Version 16.11.8
VisualStudio.16.Release/16.11.8+32002.261
Microsoft .NET Framework
Version 4.8.04084

Installed Version: Community

Microsoft Visual Studio Tools for Applications 2019 00435-60000-00000-AA039
Microsoft Visual Studio Tools for Applications 2019

Azure App Service Tools v3.0.0 16.11.94.52318
Azure App Service Tools v3.0.0

C# Tools 3.11.0-4.21403.6+ae1fff344d46976624e68ae17164e0607ab68b10
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Common Azure Tools 1.10
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

NuGet Package Manager 5.11.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit https://docs.nuget.org/

ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info

SQL Server Data Tools 16.0.62111.25150
Microsoft SQL Server Data Tools

SQL Server Integration Services 15.0.2000.170
Microsoft SQL Server Integration Services Designer
Version 15.0.2000.170

Visual Basic Tools 3.11.0-4.21403.6+ae1fff344d46976624e68ae17164e0607ab68b10
Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual Studio Code Debug Adapter Host Package 1.0
Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

Thank you

Accepted answer

0 additional answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @Manny ,

Are you opening a saved package instead of creating a new package?

The component metadata for "Power Query Source, clsid {7CDF593F-DE06-4ABD-B356-7976EF7AC8E0}" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

Generally this means that the component was upgraded after the package was saved, and so it's at the wrong version number.

Please try to re-add the component to see if it could work.

In addition, for the current preview release, Power Query Source can only be used on SQL Server 2017/2019 and Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF). You can download and install the latest Power Query Source for SQL Server 2017/2019 from here.

power-query-source

Make sure that you have installed 32bit for SSDT is 32bit.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Manny 151 Reputation points

2022-01-18T16:47:21.257+00:00

Hi Zoe

Thank you for the reply.

I created a new package. When you say "re-add the component" what do you mean exactly? Do you mean remove the Power Query Source in the Toolbox section and re-install it? Or are you saying in the design grid where the Power Query Source was dropped into to make the data flow chart?

How would I check if SSDT is 32 bit or not?

I tried this as well...I removed the package and started fresh. I created a new package and re-added the two items (Power Query Source and OLE DB Destination). Still same issue. I tested the connections for both and they both passed. Should I uninstall VS and related parts and then re-install it?

Thank you
ZoeHui-MSFT 41,491 Reputation points

2022-01-19T01:21:29.26+00:00

Hi @Manny ,

SSDT is 32bit, you do not need to check that. Just try to install the 32bit Power Query Source and then create the package.
Manny 151 Reputation points

2022-01-19T03:52:37.863+00:00

Hi @ZoeHui-MSFT

I uninstalled Power Query. I confirmed it was gone because the icon was not appearing in toolbox section. I installed x86 version of Power Query. Still getting same error. I tried to paste the new error but it said it was too many characters. Any suggestions? Thank you
ZoeHui-MSFT 41,491 Reputation points

2022-01-19T07:37:53.58+00:00

Hi @Manny ,

SsisPowerQuery_2019_x64.msi and SsisPowerQuery_2019_x86.msi are targeting SQL Server 2019 with different architectures.
SsisPowerQuery_2017_x64.msi and SsisPowerQuery_2017_x86.msi are targeting SQL Server 2017 with different architectures.

Please check your target SQL Server, Right click on the project name, then choose Properties-->Expand Configuration Properties, then click on General, and then choose the desired SQL Server Version for the TargetServerVersion property.

Please have a double check on it.
Manny 151 Reputation points

2022-01-19T16:28:51.823+00:00

Hi @ZoeHui-MSFT

I checked. It is SQL Server 2019 and I am using the same version of SQL Server. Should I uninstall Visual Studio and re-install it?

Thank you
ZoeHui-MSFT 41,491 Reputation points

2022-01-20T01:23:12.073+00:00

Hi @Manny ,
You may have a try to uninstall Visual Studio and re-install it. You may also use VS2017 to have a compare.
Manny 151 Reputation points

2022-01-20T05:05:57.013+00:00

Hi @ZoeHui-MSFT

I am still getting same error. I removed old VS2019 and installed it again. There is no 64 bit version so I installed 32 bit version. Power Query is 32 bit. Still getting same error. What do you suggest?

Thank you
ZoeHui-MSFT 41,491 Reputation points

2022-01-20T07:56:11.76+00:00

Hi @Manny ,
Could you please check if you have set the Run64BitRuntime to false?

If possible, could you help install the VS2017 to see if the issue still occur. I could not re-produce your issue in my side.
Manny 151 Reputation points

2022-01-20T18:10:56.613+00:00

Hi @ZoeHui-MSFT

It works!!! I had to change that flag from TRUE to FALSE and now it works!!

Question ... going forward, are there going to be any problems if I set that flag to FALSE?

Thank you

Share via

SSIS Error

ERROR

SYSTEM INFO

0 additional answers

Your answer