I have built a package using VS2017. It has a script task that checks to see if files exist. I am getting an error when I schedule it to run in SQL 2016.
Executed as user: ct\svc-dwep-ilx. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 32-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 10:57:09 AM Error: 2018-07-30 10:57:10.05 Code: 0x00000001 Source: Script Task Description: Exception has been thrown by the target of an invocation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:57:09 AM Finished: 10:57:10 AM Elapsed: 0.703 seconds. The package execution failed. The step failed.
