SSIS RDS - Dynamic connection to S3 buckets

0

We had SSIS packages that were using File System and we are planning to change it to use S3 buckets . So used a third party tool - Zappysys for taking care of this task to access / move / process with S3 buckets . It was working fine . We are also having a plan to move SSIS packages to RDS Server - then we started checking and it showed up a lot of tasks which isn't supported in the RDS - like script tasks or script components . We did change or found a solution to handle those logic by avoiding script tasks or components . Now - we have the hurdle of connecting SSIS RDS packages to S3 buckets - which are dynamic by env and by client . Would like to know if there are services that can take care of this from the SSIS packages which are in RDS server or does AWS provide option to open up to use third party tools .

1 Risposta
0

While RDS does not allow direct integration with multiple S3 buckets, you could consider Glue jobs for this scenario.

Schema Conversion Tool (SCT) provides an SSIS package conversion option that can be used a starting point.

This blog post might help.

AWS
con risposta 10 mesi fa
  • Thanks Adrian will check this

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande