Amazon RDS support for SQL Server Integration Services

    14
    8



    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: https://amzn.to/3gjQm6A
    Seamlessly Join a Windows EC2 Instance – https://amzn.to/3grbpny
    Support for SQL Server Integration Services in SQL Server- https://amzn.to/3legNOK
    Using Windows Authentication with an Amazon RDS for SQL Server DB Instance – https://amzn.to/2YvwgjG
    Integrating an Amazon RDS for SQL Server DB Instance with Amazon S3 – https://amzn.to/3gnC4lj

    Subscribe:
    More AWS videos http://bit.ly/2O3zS75
    More AWS events videos http://bit.ly/316g9t4

    #AWS #AWSDemo #AmazonRDS

    source

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

    8 COMMENTS

    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?