Forum Discussion

Prasant2999's avatar
Prasant2999
Copper Contributor
Jul 27, 2020

SSIS Package is working fine in SSDT but giving error in SQL Agent JOB

Hi,

I get same issue while running the SQL Agent job which executes SSIS package. The SSIS package job runs well when we run in VS manually, but throws error from SQL agent. Below are the details of config.

SSMS v18.6
in dtsx pacage the TargetServerVersion is Sql Server 2019
SSDT for VS 2017 v15.9.25

Error - Description: Cannot create a task from XML for task "Get PackageRun Stats", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect."
Below steps are performed.
1. I have installed Microsoft.DataTools.IntegrationServices
2. Repair the VS

Please help

Resources