SSIS package Error: Cannot create a task from XML for task "Script Task", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".

TC 81 Reputation points
2022-10-28T02:58:48.42+00:00

Hi,

I get error while running DTExec.exe in cmd which executes SSIS package. The SSIS package job runs well when I run in VS 2019 manually, but throws error from cmd.

command I have executed in cmd: "C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTExec.exe" /f "C:\Users\XXXX\source\repos\SSIS data ingestion\package.dtsx"

Below are the details of config.

SQL Server 2019
VS community 2019
SSMS v18.12.1
SSDT v16.0.62205.05200

info from SSMS
SQL Server Management Studio 15.0.18424.0
SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.19041.2130
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044

Detail of Error Message:

Started:  9:53:58 am  
Error: 2022-10-28 09:53:59.49  
   Code: 0xC001F02A  
   Source: Foreach metadata file name  
   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-28 09:53:59.49  
   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-28 09:53:59.49  
   Code: 0xC001F02A  
   Source: Foreach metadata file name (KTP)  
   Description: Cannot create a task from XML for task "Deserialize metadata file", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".  
End Error  
Error: 2022-10-28 09:53:59.49  
   Code: 0xC0010018  
   Source: Deserialize metadata file  
   Description: Failed to load task "Deserialize metadata file", type "". The contact information for this task is "".  
End Error  
Error: 2022-10-28 09:53:59.56  
   Code: 0xC0010026  
   Source: Deserialize metadata file  
   Description: The task has failed to load. The contact information for this task is "".  
End Error  
Error: 2022-10-28 09:53:59.56  
   Code: 0xC0024107  
   Source: Deserialize metadata file  
   Description: There were errors during task validation.  
End Error  
Error: 2022-10-28 09:53:59.56  
   Code: 0xC0010025  
   Source: Package  
   Description: The package cannot execute because it contains tasks that failed to load.  
End Error  
DTExec: The package execution returned DTSER_FAILURE (1).  
Started:  9:53:58 am  
Finished: 9:53:59 am  
Elapsed:  0.672 seconds  
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 35,546 Reputation points
    2022-10-28T06:21:47.19+00:00

    Hi @TC

    You may not be able to execute the complex SSIS packages that contains any tasks / components like Script tasks, Script components, Sort / Aggregate/ Fuzzy Lookup transformations etc. using the DTEXEC.exe / DTEXECUI.exe runtimes outside your developer tools without having Integration services installed on that machine. SSIS packages aren’t meant to be executed this way.

    Please make sure that you have installed Integration services on your machine.

    See Running SSIS packages outside the Developer tools using DTEXEC.exe.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful