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