How to deploy SSIS package on AWS RDS?

• Vallu

  SSC Eights!

  Points: 863

  More actions

  February 25, 2016 at 4:46 am

  #325065

  Hi All,

  I got a RDS (AWS) account from my client and I have to deploy SSIS packages over the network but when trying to deploy it is looking for work based on Windows Authentication mode but in RDS we won't get windows authentication mode (even how can we access any system's (over the network ) windows authentication details. can any one help me on how to deploy my SSIS package on amazon's RDS?

  Thanks

  Ashok Vallu

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738217

  More actions

  March 29, 2016 at 2:59 pm

  #1868415

  According to Amazon's RDS docs, SSIS/RS/AS aren't on RDS. You need an EC2 or on-premise instance to run these: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

  I did see recently that Amazon was integrating AD with AWS in some way, but I doubt you'll see SSIS added anytime soon to RDS.

  Other items:

  http://stackoverflow.com/questions/30057091/does-amazon-rds-for-sql-server-support-ssis

  http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html