• As i quoted already from the official AWS documentation you cannot utilise SSIS in RDS SQL Server instances currently as its not supported.

    One option you have is to run a EC2 instance that can execute the SSIS packages using something like dtexec rather than a full SQL instance running the packages via SQL agent jobs, the packages can still log to the catalog but you cannot deploy them to the instance.

    In order to do what your asking you will have to run a full SQL server install on an EC2 instance.

    This is one of the contributing factors to why we do not run SQL server in AWS and instead run MySQL RDS instances for basic database functionality and SQL server in our own data centers.

    MCITP SQL 2005, MCSA SQL 2012