We execute SSIS package using below command written in a batch file. (On premises MSSQL DB) D:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTEXEC.exe>" "E:\Packages\SSISPKG1.dtsx" /Config "E:\Packages\Config\config.dtsConfig".
Now we migrate to AWS RDS-MSSQL service. How to execute .dtsx file stored in S3 bucket. What is the path of DTEXEC.exe for RDS - MSSQL. (Microsoft SQL Server)?
As I am assuming, RDS-MSSQL Service create an hidden EC2 instance for processing and storing data. Is it possible to create a folder on that instance to keep .dtsx file and run a batch file when needed?
RDS supports only project deployment mode. There is a tutorial:
Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server