0

Identical question with no answers.

I have an issue with my SSIS projects where I cannot create a project that has a Microsoft.ScriptTask in it without encountering some bizarre error messages. The underlying issue is that the content of the Microsoft.ScriptTask doesn't matter. The task can be empty and it will result in an identical error.

All scripts ran within Visual Studio work fine.

I have looked at multiple solutions including:

  1. Checking in your program files to see if the right version of DTExec is being used. As shown in the excerpt, I am indeed using the 150 version aka SQL Server 2019.
  2. Most solutions on this page which include checking that the package version is the same as the currently downloaded version of SQL Server (they are both 2019 version 15) and checking the encryption type of the solution to see if the sensitive data could be at fault.
  3. Reinstalling SSDT.
  4. Running everything as administrator from the CMD that runs DTExec to Visual Studio 2019 which runs the code.
  5. Rebuilding the script task.
  6. As recommended by my senior, checking to see if DTExec was running on 32-bit or 64-bit. (If DTExec launches from Program Files(x86), it is most likely 32-bit. If it launches from Program Files, it is most likely 64-bit). It is indeed running on 64-bit.
  7. Another recommendation was to attempt to run the package through SSMS's Agent Profiler which resulted in the same error.
  8. Checking to see if the .Net Framework version on my computer (through checking the GAC) is the same as the target version of the package. They are both 4.8.
"C:\Program Files\Microsoft SQL Server\150\DTS\Binn\Dtexec.exe" /f "C:\Directory\Documents\SSIS Tests\TEST_PROJECT\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 15.0.2000.5 for 64-bit
Copyright (C) 2019 Microsoft. All rights reserved.

Started:  16:35:16
Error: 2022-10-20 16:35:17.17
   Code: 0xC001F02A
   Source: Sequence Container
   Description: Cannot create a task from XML for task "Script Task", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".
End Error
Error: 2022-10-20 16:35:17.17
   Code: 0xC0010018
   Source: Script Task
   Description: Failed to load task "Script Task", type "". The contact information for this task is "".
End Error
Error: 2022-10-20 16:35:17.18
   Code: 0xC0010026
   Source: Script Task
   Description: The task has failed to load. The contact information for this task is "".
End Error
Error: 2022-10-20 16:35:17.18
   Code: 0xC0024107
   Source: Script Task
   Description: There were errors during task validation.
End Error
Error: 2022-10-20 16:35:17.18
   Code: 0xC0010025
   Source: Package
   Description: The package cannot execute because it contains tasks that failed to load.
End Error

I hope this is enough information and that someone can help. Thank you.

Mitchell Mastromonaco
  • 21
  • 1
  • 1
  • 5
  • Do you have other SQL Server 2019 instances on which you could test the package? i.e.: Does the package execute successfully on a different server, suggesting configuration issues on the current one? Does the problem server actually have the Integration Services components installed? Is the problem server [up to date](https://learn.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server)? – AlwaysLearning Oct 20 '22 at 22:30

1 Answers1

0

As per AlwaysLearning's comment, the issue was with my SQL Server installation. I hadn't downloaded SSIS when I originally installed my SQL Server instance which meant that none of my SSIS packages were running properly.

Mitchell Mastromonaco
  • 21
  • 1
  • 1
  • 5