question

fantumahi2 avatar image
fantumahi2 asked

ssis schdule in ssms

I installed sql server 2017 including SSDT . there is a pckage i created on SSIS and i want to schdule it in SSMS . when i run the job . this is the error i am getting . "Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 14.0.2027.2 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 11:44:39 PM Error: 2019-08-01 23:44:39.57 Code: 0xC001F02A Source: Package Description: Cannot create a task from XML for task "Execute Process Task", type "Microsoft.ExecuteProcess" due to error 0x80070057 "The parameter is incorrect.". End Error Error: 2019-08-01 23:44:39.57 Code: 0xC0010018 Source: Execute Process Task Description: Failed to load task "Execute Process Task", type "". The contact information for this task is "". End Error Error: 2019-08-01 23:44:39.57 Code: 0xC0010026 Source: Execute Process Task Description: The task has failed to load. The contact information for this task is "". End Error Error: 2019-08-01 23:44:39.57 Code: 0xC0024107 Source: Execute Process Task Description: There were errors during task validation. End Error Error: 2019-08-01 23:44:39.57 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: 11:44:39 PM Finished: 11:44:39 PM Elapsed: 0.141 seconds. The package execution failed. The step failed." .

I tried everything even by googling. anyone can help?

ssissql-serverssmssql-agent
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·

What is the process task doing? The error states that the parameter for "Execute Process Task" is incorrect.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.