We are in the middle of a BI upgrade project and was testing the script task.
We are having a weird issue with a deployed package using a vb script task.
To recreate the issue
We created a new package in SSDT 17.3 build 14.0.61709.290 targeted 2016 with a script task and a mail task .. I have a read\write variable named date, I create the VB script task to assign the date variable current date time. I then mail the new value.
When we test on our developers machines (more then one testing) the scripts run fine no issues.
When we deploy to our SQL 2016 server the VB script is not running and not setting the variable.
If I copy the package to the server and then deploy from the server, the scripts runs as expected.
Can anyone direct me to what is going on and what the issue is?