Thank you for detailed video. I am trying to deploy an ssis package with a script task which does not seem to be allowed currently. Hopefully we would be able to do that soon.
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-folder\projectname\childpackagename.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?
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.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
you saved me time.... thanks a lot
Thank you for detailed video.
I am trying to deploy an ssis package with a script task which does not seem to be allowed currently. Hopefully we would be able to do that soon.
Thanks, I liked it the way you present demo. Keep it up
How we can schedule SSIS package execution from RDS instance?
can we able to connect to other databases such as oracle, aurora and deploy the packages in managed RDS?
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-folder\projectname\childpackagename.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?
Is there any way to output to a flat file using the flat file connector?
Are we able to load data from .dat file. RDS throwing error cannot open data file.
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.