0

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.

enter image description here

enter image description here

SSIS is installed

enter image description here

  • Welcome to DBA.SE. Could you click on the Show details button in the error message and post the details in your question? Hit edit and add the details directly underneath the screenshot. Thanks. – John K. N. Nov 3 '20 at 6:38
  • @Johnakahot2use - I added the error details, thanks! – mannaggia Nov 3 '20 at 12:40
  • Are you trying from this a client machine pointing to a SQL Server instance or are you running this from the SQL Server instance server ? Which version of SSMS are you using ? – armitage Nov 3 '20 at 13:02
  • @armitage It is all running on the same system, a Windows 10 Pro system, all services. It is running SQL Server 2019 Developer Edition. SSMS is version 18.7. It also has VS 2019 installed. – mannaggia Nov 3 '20 at 14:31
0

Hmm interesting it's calling out SSIS. This is just going out in a limb, but can you use the SQL installer to ensure SSIS is installed and then retry: https://docs.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver15

Hopefully that fixes the underlying issue.

  • 1
    SSIS is installed (added a screen shot in my original post). – mannaggia Nov 3 '20 at 12:43
  • Is the Windows service for SSIS currently running? Click Start -> Run -> type services and then look for SQL Server Integration Services and verify the Status says "Running". – J.D. Nov 3 '20 at 13:49
  • 1
    Yes, it is running. And I've also tried running it as the user the SQL Server installer creates and as LocalSystem. – mannaggia Nov 3 '20 at 14:28
  • Yea I think you unfortunately have a very specific odd issue. You might have to reach out to Microsoft for help with this one. The only other thing I can think of is when you registered DTSPipeline.dll and DTS.dll with regsvr32, did you do it from the command line running as administrator mode? – J.D. Nov 3 '20 at 18:56
  • 1
    Yes, I did do it using Run as Administrator (started Command Prompt using Run As Administrator) – mannaggia Nov 4 '20 at 15:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.