> ## Documentation Index
> Fetch the complete documentation index at: https://rajanand.org/llms.txt
> Use this file to discover all available pages before exploring further.

# SSIS Error: Cannot create a task from XML for task

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

## Background:

I have created a SSIS package in visual studio 2019 and tested it. It was working fine. When I tried executing the package from the SQL Server agent, I was getting different errors.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1675190182771/701ba9bf-d62e-4828-bfc7-977a0662490d.png)

This is the simplified version of the package. Even though the "Execute process task" was disabled, this generated an error when the package (XML file) was loaded. I was trying to find more on the first two issues (0xC001F02A and 0xC0010018). But the actual reason the package has failed is SQL Server Integration Services feature was not installed when the SQL Server was installed. That is evident from the third error message.

Error message from SQL Server Agent job history:

> Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved.\
> Started: 1:30:20 PM
>
> Error: 2023-01-31 13:30:22.07\
> Code: **0xC001F02A**\
> Source: TestPackage\
> Description: **Cannot create a task from XML for task "sftp download", type "Microsoft.ExecuteProcess" due to error 0x80070057**\
> **"The parameter is incorrect."**.\
> End Error
>
> Error: 2023-01-31 13:30:22.07\
> Code: **0xC0010018**\
> Source: sftp download\
> Description: **Failed to load task "sftp download", type "".\
> The contact information for this task is "".**\
> End Error
>
> Error: 2023-01-31 13:30:22.95\
> Code: **0xC000F427**\
> Source: clean-up-folder\
> Description: **To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services** or higher.\
> End Error
>
> DTExec: The package execution returned DTSER\_FAILURE (1).\
> Started: 1:30:20 PM Finished: 1:30:23 PM Elapsed: 2.063 seconds.\
> The package execution failed. The step failed.

After removing the "Execute Process Task" from the package, the only error I got was the SSIS was not installed.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1675189483402/af9e9910-ac40-4190-84fb-d60859602ed2.png)

> Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved.\
> Started: 10:26:12 AM
>
> Error: 2023-01-31 10:26:14.28\
> Code: **0xC000F427**\
> Source: clean-up-folder\
> Description: **To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services** or higher.\
> End Error
>
> DTExec: The package execution returned DTSER\_FAILURE (1).\
> Started: 10:26:12 AM Finished: 10:26:14 AM Elapsed: 1.734 seconds.\
> The package execution failed. The step failed.

## Solution

This issue has been resolved once the SQL Server Integration Services feature is installed and the server is rebooted.

Hope this helps to resolve your issue. If you have any questions, please let me know.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.