We have SSIS packages and a SQL Server database. We have to migrate our data and packages to a new database, and our SSIS packages have been troublesome.
The packages are a SQL task -> Data Flow Task -> SQL Task -> Script Task. SSMS is throwing an error on the script task. I do not have permissions to access the server directly and run VS from there. On my local machine, everything runs fine.
We determined that the script task is actually unnecessary in the process, so I deleted that step and re-deployed the packages. However, it's throwing the exact same script task error despite the script task not being there anymore.
If I recreate the package without the script task ever being involved, it runs just fine. I would need to recreate a huge amount of packages, so I'm trying to avoid this at all costs.
Does anybody have any ideas?
We figured out the solution. In the Package Explorer, I needed to drill down into Executables > Insert Sequence Container Name Here > Event Handlers > OnPreExecute > Executables > Script Task. Delete the script task there and then deploy. Now the script task is gone for good and the package runs successfully.