Did SQL Server Integration Services support Script Taks?

Unfortunately, the "Script Task" is one of the Control Flow tasks that is not included on the list of supported control flow tasks on RDS SSIS currently.

Please see the list of control flow tasks that are supported on RDS SSIS .

• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSIS.html#SSIS.Limitations

As you can see in the list , the following control flow tasks only are supported in RDS SSIS and "ScriptTask" is NOT supported currently .

Analysis Services Execute DDL Task
Analysis Services Processing Task
Bulk Insert Task
Check Database Integrity Task
Data Flow Task
Data Mining Query Task
Data Profiling Task
Execute Package Task
Execute SQL Server Agent Job Task
Execute SQL Task
Execute T-SQL Statement Task
Notify Operator Task
Rebuild Index Task
Reorganize Index Task
Shrink Database Task
Transfer Database Task
Transfer Jobs Task
Transfer Logins Task
Transfer SQL Server Objects Task
Update Statistics Task

Kindly note that RDS as a Managed Service does not provide host level access (OS level access). The script task option in control flow is not supported since SSIS package containing ScriptTask for C# and VB code to be executed, it can potentially require access to the underlying OS/host , which may break RDS as a Managed Database service overall as per the existing RDS design and architecture. The restricted access and control on the underlying OS\host is the main reason as why "Script Task" is not supported in SSIS on RDS as of now . Unfortunately there are no direct solution that exists to overcome this limitation on RDS SSIS as of now.

With respect to this , I would like to keep you informed that there is already a feature request existing on this requirement of supporting SSIS Script Task in Control flow in RDS SQL Server SSIS and our Internal RDS product team is aware of this. They are currently looking into the possibility to bring this feature in to RDS SQL Server SSIS in accordance to the OS level restriction.

However, I will not be able to provide an ETA on when this feature will be implemented & released , since any new feature/fix requires rigorous testing and compatibility checks by the RDS engineering team before they can be deployed globally.

You can keep track of new features released on the official AWS Updates sources:

[1] RDS What's New - https://aws.amazon.com/new/

[2] AWS Database Blog - https://aws.amazon.com/blogs/database/

[3] AWS Blog - https://aws.amazon.com/blogs/aws/

Once again , I sincerely apologize on AWS behalf if the current limitation of Script Task not supported on RDS SQL Server SSIS has caused any kind of inconvenience to your requirement.