I have SSIS Package created in 2008. I opened the package in Visual studio 2017 and updated the TargetServerVersion as 2012.
SQL Server Database version: 2019
SSMS installed version: 2012
When i run the package in Viusal studio I am not getting any error. But when I run the package via batch file using the dtexec command i am getting error.
Error: 2021-10-26 11:06:11.26
Source: Send Mail Task
Description: To run a SSIS package outside of SQL Server Data Tools you must
install Send Mail Task of Integration Services or higher.
The package has script task and data flow task and is failing. Only Execute SQL task is running without any issues.
Please update me the reason for failing in dtexec command alone when it is running fine in Visual studio.