Amazon RDS support for SQL Server Integration Services


    Learn how to deploy your SQL Server Integration Services (SSIS) packages on Amazon RDS. In this video, you will learn about prerequisites, limitations, and the process of deploying packages on Amazon RDS instances.

    Learn more:
    Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server:
    Seamlessly Join a Windows EC2 Instance –
    Support for SQL Server Integration Services in SQL Server-
    Using Windows Authentication with an Amazon RDS for SQL Server DB Instance –
    Integrating an Amazon RDS for SQL Server DB Instance with Amazon S3 –

    More AWS videos
    More AWS events videos

    #AWS #AWSDemo #AmazonRDS


    Previous articleBest Guitar For Blues: Custom Shop Vs American Standard Strat
    Next articleAWS Lambda : Schedule Using Eventbridge Rule


    1. Nice video! Nothing to take away from the info in this video but unfortunately, running SQL Server via RDS or EC2 is extremely expensive and very restrictive. As an example, AWS has no way of running 256gb of memory with anything less than 32 cores. Anyone that has spent any time at all using and running SQL Server knows that throwing a bunch of CPU at a SQL Server is a waste. You may as well just throwing money in a can and light it on fire. Memory, disk speed, and network speed are the main ingredients to making SQL Server run well. You can easily run SQL Server with 8 cores and 256gb of memory and it will run just as good as the R5.8xlarge which has 32 cores. It's simply a waste of the customer's money.

    2. Is it possible to call child packages from a parent package in RDS? I have 2 dtsx files in the SSIS Catalog where one call's the other, the Connection String has a file path (D:S3) which I updated when I imported into the SSIS Catalog on the RDS database to point to the SSIS Catalog path e.g sample-ssis-folderprojectnamechildpackagename.dtsx however it doesn't seem to be able to read it ("The system cannot find the file specified). Does RDS support parent/child packages?