Due to error 0x80070057" The parameter is incorrect." SSIS job failed to run

3
votes

I have a SSIS job which run well in SQL Server 2008 but no longer working in SQL Server 2017. The error message I get is:

Cannot create a task from XML for Task "Email", type "Microsoft.Script.Task" due to error 0x80070057" The parameter is incorrect

Kindly advise any solution for this problem. Thanks

1
sql-serversql-server-2008ssissql-server-2017
Are you using ActiveX scripting? – GSerg
I think no, do you have any idea why it mentioned pass in parameter incorrect? Even though the config file is setup correctly – Hao
SSIS engine in SQL Server is version specific and is known to have poor backward compatibility (i.e. total lack of backward compatibility). You need to upgrade your SSIS packages to the correct version before re-deploying them on newer SQL Server versions. – Alex
This should get you started: docs.microsoft.com/en-us/sql/integration-services/… – Alex
I have try to create new SSIS package file using script task with empty function and use sql server 2017 job to call on it and also faced same issues. Any idea how to deal with this? – Hao

1 Answers

3
votes

SSIS solutions that have been used on SQL Server 2008 R2, must be migrated to work properly on 2016/2017. The XML structure of the ssis packages is completely different and I belive 2008 packages only was supported until 2012/2014.

The process of doing this is basicly.

  1. Install VS2017 and newest version of SSDT
  2. Open SSIS project and run migration wizard
  3. Solve migration conflicts
  4. Build and deploy