I'm getting an error immediately upon starting the SQL Server 2019 Import and Export (64-bit) wizard, and I'm looking for ideas. The error is:
The SSIS Data Flow Task could not be created. Verify that the DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate.
Additional information:
Cannot create a task from XML for task "", type ", {D9DA2996-AD06-4166-9C0C-C53E29834AF2}" due to error 0xC0000002 "".
({50E060E2-93A0-4F72-9DB6-F692E561312A})
A screen shot of the error is below.
I have tried everything I can think of or find online, including:
- register DTSPipeline.dll and DTS.dll with regsvr32 from the 150 folder
- install latest CU of SQL Server 2019
- repair SQL Server 2019 using the installer
- uninstall everything that mentions SQL Server from the control panel
- re-install SQL Server 2019 after uninstalling everything
- try again prior to installing latest CU
- try again after installing latest CU after re-install of SQL Server 2019
- try with Run As Administrator
- re-install Microsoft.DataTools.IntegrationServices.exe
- install latest SSMS
Nothing changes it. Even after totally removing SQL Server 2019 and re-installing.
I can't think of what else to try.
SSIS is installed