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 Answer
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
answered 10 months ago
  • Thanks Adrian will check this

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions