Hi.. I have a SSIS package running against 2016 SQL server created from SSDT 2015 that fails in VCRON but runs OK in SSIS.
I have used all the setting I know to fix this like.. run in 32 bit mode, solution properties are set for 2016, store sensitive with PW protect.
I even used trusted credentials, but nothing works.
I have both SSDT and full VS 2015 installed on same machine... which is in WinOS 2016 Server.
NOTE that the SSIS package calls a .NET script to see check the date and decides what option to run.
Still Getting this error...
Error(-1073679321): To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.
Does anyone have any ideas how to fix ?
Thanks,
Paul.
Edited by user
2018-02-27T00:33:00Z
|
Reason: added technical details