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

3

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

sql-server
sql-server-2008
ssis
sql-server-2017
asked on Stack Overflow Jun 29, 2019 by Hao • edited Jun 29, 2019 by marc_s

1 Answer

1

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
answered on Stack Overflow Jul 4, 2019 by Ruben RavnÄ

User contributions licensed under CC BY-SA 3.0