I'm trying to deploy an SSIS task onto a server and I'm getting the following error:
The task in question is a Script Task and the SSIS package is loaded from the file system and executed with C#. It connects to a spreadsheet and retrieves the first worksheets name. It works fine locally but not on the server. The version of SQL Server installed is Enterprise Edition.The task "script task" cannot run on this edition of Integration Services. It requires a higher level edition
I didn't write the package, my development manager did and he's on holiday for 2 weeks and the client is in tomorrow.
Has anyone came across this? It's possibly my fault, I haven't really worked with SSIS before. I'm now going to have to replicate what the script does in C#, so any suggestions that saves me from doing so will be greatly appreciated!